ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting Notepad.exe text in Excel including leading spaces (https://www.excelbanter.com/excel-programming/344690-getting-notepad-exe-text-excel-including-leading-spaces.html)

Sally[_5_]

Getting Notepad.exe text in Excel including leading spaces
 
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?



Dave Peterson

Getting Notepad.exe text in Excel including leading spaces
 
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.



Sally wrote:

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?


--

Dave Peterson


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com