how to extract figure from CELL A to CELL B,C,D,E,F

[hkbhansali]

hi,
i have a figure in CELL A1 is 3.00 2.85 23.23 0.08 12.22 now i want extract this in different cell like
CELL B1 , C1 , D1 , E1, F1
3.00, 2.85, 23.23, 0.08, 12.22


Please help

 

[VoG]

Select the cells with data in column A.

Data > Text to Columns, Delimited and specify Space as the delimiter, then click Finish.

 

[hkbhansali]

Thanks VoG, Superb

 

[MAHMOUD-LEE]

You can use this formula, and dragging them to the right and down
=TRIM(MID(SUBSTITUTE($A1;" ";REPT(" ";255));COLUMN(A1)*255-254;255))*1