| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IMPORTING PC-DOS PLAIN TEXT FILES WITH LEADING SPACES | Excel Discussion (Misc queries) | |||
| What excel snyntax and or function will add leading spaces | Excel Worksheet Functions | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| How keep Leading/Trailing spaces when save in Excel? | Excel Discussion (Misc queries) | |||
| Saving XL ranges as Fixed Field Length Text - Leading spaces | Excel Programming | |||
![Sally[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
