How do I re arrange numbers

R

Raz

I copied and pasted a table of numbers from another file (converted a pdf to
excel) that looks like this. (only 4 rows shown here)

102050903818W400 1 6 7.60 334.10 38.86 214.26 211.82 28.29
-14.05 32.66 0.18
102050903818W400 1 7 7.60 338.90 38.98 253.24 250.46 33.01
-16.11 37.81 0.49
102050903818W400 1 8 7.40 335.30 38.86 292.10 288.99 37.69
-18.08 42.89 0.39
102050903818W400 1 9 7.40 336.10 38.84 330.94 327.51 42.24
-20.14 47.88 0.08

All these numbers are in the first column, and with spaces (more than one)
between them. I would like to separate them into different columns with a
simple equation or function. IS THIS POSSIBLE?? please help.




I want these numbers to be like this (Now they are all in A4 to A 160)

H4 I4 J4 K4 L4 M4 N4
O4 P4
102050903818W400 1 6 7.60 334.10 38.86 214.26 211.82 28.29

Q4 R4 S4
14.05 32.66 0.18
 
P

Pete_UK

Use Data | Text-to-columns and specify <space> as the delimiter. Just
work through the Wizard.

Hope this helps.

Pete
 
R

Raz

thanks, exactly what i was looking for,


Pete_UK said:
Use Data | Text-to-columns and specify <space> as the delimiter. Just
work through the Wizard.

Hope this helps.

Pete
Click to expand...
 
Top