Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In column D of my worksheet some of the cell contents have a varying number
of spaces. How can I removed any leading spaces from those cells with VBA? There are spaces within the cells (not leading) that I want to keep. Example below. Here is what I have now: ColD This is the text Blah Blah Blah Blah Blah Blah Blah This is the text Here is what I'd like to end up with: ColD This is the text Blah Blah Blah Blah Blah Blah Blah This is the text Thanks in advance! Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I remove leading spaces the column is left justified | Excel Discussion (Misc queries) | |||
how do you remove leading spaces etc in cells? | New Users to Excel | |||
remove leading spaces | Excel Worksheet Functions | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
Remove Leading Spaces | Excel Discussion (Misc queries) |