Notepad or .txt file to excel
Select the imported text and then use
Data -- Text to columns and select the space character as the delimiter.
"nathan" wrote:
I have a notepad file with thousands of rows of information. I want to copy
it to excel. It copies very well each line into separate rows. But......I
would like......a million dollars......
Is there a way after each space in the notepad file to put that information
in the next column? So I copy information out of notepad into excel and have
the information in separate cells and columns?
|