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?

Having copied it into Excel, use Data/ Text to columns, with space as
delimiter.
Otherwise, pull the txt into Excel with Data/ Import external data/ Import
data, and specify space as delimiter in the text import wizard.
--
David Biddulph

"nathan" wrote in message
...
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?

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?

Here are two visual tutorials that do the same:
http://www.worldstart.com/tips/tips.php/1153

http://www.youtube.com/watch?v=y17NLIoDqtg
(voice is pretty annoying, but it's less than 2 min. so just bear with it...)

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"JLatham" wrote:

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?