Transporting text files from notepad to excel
In the Excel file open dialog box, select *.txt as the type of file to open
and open it. It will very likely import all the text into the first column in
the worksheet. Select the first column and then use Text to Columns to
separate it into the various columns. You will find Text to Columns under
Data.
When you save, use Save As and save as an Excel file not a txt file. You
need to do this to keep all the Excel features and it will not overwrite the
txt file because it has a different extension.
Regards,
OssieMac
" wrote:
I wanted to extract text from a notepad then transport them into
excel. Any help would help.
Thanks!
|