Transfering text to excel spreadsheet

C

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
 
B

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
 
D

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)
 
C

Charles Shahar

Thanks a bunch! It works!!!

-Charles

Bernard Liengme said:
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
Click to expand...
 
C

Charles Shahar

Thanks a bunch! It works!!!

-Charles


Dave Peterson said:
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)
Click to expand...
 
Top