| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
When importing text field Excel chops off leading spaces
On Sun, 24 Jul 2011 13:52:32 -0700 (PDT), septimus wrote:
Hm. That does seem to work. Maybe not the most elegant solution in the world, but it does appear to get the job done. Thanks! Glad to help. Since the method seems to work, you could probably simplify things using a macro. By the way, when I import the data "delimited", the leading spaces seem to be preserved. But you probably know that. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IMPORTING PC-DOS PLAIN TEXT FILES WITH LEADING SPACES | Excel Discussion (Misc queries) | |||
| Importing Text File into Excel loses leading zero on some fields. | Excel Programming | |||
| Getting Notepad.exe text in Excel including leading spaces | Excel Programming | |||
| Excel "chops off" half of first line of text | Excel Discussion (Misc queries) | |||
| Saving XL ranges as Fixed Field Length Text - Leading spaces | Excel Programming | |||
![Ron Rosenfeld[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
