text file to excel

[brian]

I am trying to save a text file (example shown below) as a excel file (.xls)
The resulting excel file has all the fields in one column.

How to get the individual fields in a given row into different columns ?

line1 col2 hello
line2 col2 hello
line3 col2 hello

 

[DDM]

Brian, use the "Text to Columns" feature on the Data menu. Your text is
delimited, and the delimiter is a space.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com