Notepad or .txt file to excel

N

nathan

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?
 
D

David Biddulph

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.
 
J

JLatham

Select the imported text and then use
Data --> Text to columns and select the space character as the delimiter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top