Transfering text to excel spreadsheet

[Charles Shahar]

Hi everyone: I have columns of numbers which I can access in Notepad. I
would like to export these columns to Excel so that I can sort them, etc.
The columns themselves are not divided by tabs. Any ideas how I can do this?
Thanks,

-Charles

 

[Bernard Liengme]

Try
1) From Excel use File|Open -> all files -> select your txt file
or
2) Copy from Notepad to Excel and use Data|Text to Column

best wishes

 

[Dave Peterson]

Copy them in notepad.
paste into column A of a new worksheet

then select column A
then data|text to columns

You can specify delimited by space (or multiple spaces)

 

[Charles Shahar]

Thanks a bunch! It works!!!

-Charles

Try
1) From Excel use File|Open -> all files -> select your txt file
or
2) Copy from Notepad to Excel and use Data|Text to Column

best wishes

 

[Charles Shahar]

Thanks a bunch! It works!!!

-Charles

Copy them in notepad.
paste into column A of a new worksheet

then select column A
then data|text to columns

You can specify delimited by space (or multiple spaces)