I listed an example below but I'm doing this for a research project and we need a quick way to extract raw data in 3 sections (highlighted in red) for each exercise. Each of these fields are listed as individual cells and needs to be extracted so we can do our calculations.

Is there a simple Excel program I can write to pull this data? I would need each of these fields copy / pasted into a new spreadsheet.

thanks in advance!


EXAMPLE:

BACKWARD DIGIT SPAN EXERCISE
Fri Sep 17 09:07:04 2010 : Time and date of exercise
: Subject identification
1 : Session number
600000 : Test time (milliseconds)
1000 : Stimulus time (milliseconds)
1000 : Inter-stimulus time (milliseconds)
pair # String Answer Response Result
1 642 246 642 Incorrect
2 871 178 178 Correct
3 4651 1564 165 Incorrect
4 3864 4683 4863 Incorrect
4 : Total number of digit spans
1 : Total number of spans correct
3 : Total number of spans incorrect
0 : Total number of spans unanswered
3 : Maximum span correct