Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing preceeding spaces
When opening specific text documents in excel, the text is
captured with 6 or 7 preceeding spaces (this is expected). I'm looking for a macro that will remove only the preceeding spaces, but not touch any spaces that appear after the first character of text. Is there a macro that can remove these? I have tried to setup a macro that copies and pastes values...etc. but to no avail. The spaces are always carried along. Thanks for your suggestions. wjd01 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Spaces | Excel Discussion (Misc queries) | |||
removing all spaces | Excel Discussion (Misc queries) | |||
Removing spaces in cell | Excel Worksheet Functions | |||
removing spaces | Excel Discussion (Misc queries) | |||
removing spaces between the numbers | Excel Discussion (Misc queries) |