Seperate Cell contents when space is found

[jordan2322]

Hi guys,

Ive got data points (X,Y,Z) Coordinates in column A seperated only by spaces - .e.g 10000 200000 300
I need to be able to split these values up into 3 seperate cells.
i.e.
column A.................Col B...........Col C..........Col D
10000 200000 300.....10000.........200000........300

until blank row is reached

regards
Jordan

[Haseeb Avarakkan]

Use Text to columns.

Select the data then go to Data >> Text to columns

Select Delimited, then click Next
In left under delimiters check "Space" then click Finish.

A formula option.

Consider data starts A2 to down. In B2, then copy across & down.

Please Login or Register  to view this content.

[jordan2322]

Cheers thanks for your reply - great function i wasnt even aware of, thank you