I have a large spread sheet pasted from elsewhere. Lines alternate.

In Cell A1,A3,A5... I have text I want to keep.
In Cells A2, A4, A6... I have a string of numbers: eg
6.580 6.590 6.500 -0.010 5.950 ........
but they may be bigger or smaller than this: eg
12.250 12.310 12.300 0.040 .........
or 0.720 0.730 0.725 0.010 ......
I want to take the third one of these numbers (eg 6.500, or 12.300, or
0.725), paste it as a number into cell B. of the row above, and then delete
the row that this number originally came from. This needs to be done as a
subroutine through the whole spreadsheet.

The final result will be text in column A, a corresponding single number in
column B, and with only half the number of lines I originally started with.

Thanks for any help.