Import non delimited txt file to Excel

[sabah320]

Hi all,..
Have been searching a lostion since a while. I have a text file with few columns which are seperated by space. When i import this to excel, i need each column from the txt file to be in a seperate column in Excel, but i get the entire txt data from txt file in a single column?.
How do i get eact column from txt file as induvidual columnin Excel?
I can mail you the sample file if needed, please mail to free2mail_82@yahoo.com so that i can send you the file.

 

[Andrew Poulsom]

Welcome to the Board.

Don't you get the Text Import Wizard that enables you to choose Delimited at Step 1 and options to choose Space as the delimiter at Step 2?