Getting Notepad.exe text in Excel including leading spaces

  • Thread starter Thread starter Sally
  • Start date Start date
S

Sally

I need to import some text from notepad into Excel. Some lines of text are
indented. I need the text to have the same indentation after it's pasted
into Excel. All of the text needs to go into columnA. Is this possible?
 
How about File|Open
point at your .txt file
When you see the text import wizard, choose Delimited.

But when you see the dialog to specify the delimiter, uncheck everything and
then finish up.
 
You must log in or register to reply here.

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

Similar Threads

Reducing the blank space around text in Excel 2007 12
hanging indent in a cell 2
How open notepad.exe and write text line by line via excel vba? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
why won't text-to-columns work here? 6
Excel Subtract text after the third space and before the fourth (from between spaces) 3
IF AND Nested Functions - Formula Not Working 0
Space round text in cells 0

Back
Top