Open a new excel worksheet ..

Open the space delimited text file ... Ctrl-A here followed by Ctrl-C

Go to the spreadsheet and Ctrl-V ....

Click on the menu item 'Data' and in the pull-down menu select Text to columns ...

Follow the prompts ...

The other option will be to do

Data --> Import External Data --> Import Data Menu to get the same job done


HTH

Sathyaram

Originally posted by geeorbit
I have a space delimited text file and I want to insert/copy the data from that file into a excel spreadsheet such that each data point goes into a different cell.

Any suggestions on how this might be done ?

Thanks in advance

:confused:
???


Originally posted by joev57
sai ram with u

itis only hello to you

Thanks Sathyaram.
The convert text to column method works well.
I had tried the import method but that was giving Run Time error 1004 for the command
.Refresh BackgroundQuery:=False

So I was looking for alternate methods to do this.

Thanks again