Import text doc to XL. Need items seperated by " " in new column

I

irvine79

Hello,
I am wondering if there is a way to take a text line "0.29 I IF IGI 1238"
and seperate it into columns based on where the space " " occurs?

Column A - 0.29
Column B - I
Column C - IF
Column D - IGI
Column E - 1238

Thanks
 
D

David Biddulph

If it's a separate text document, use Excel, File/ Open, txt documents,
browse to yours, choose delimited, select space as the delimiter.
If it's already in Excel in one column, use Data/ Text to Columns/
Delimited/ select space.
 
Top