Scott Wagner Wrote:
In column D of my worksheet some of the cell contents have a varyin
number
of spaces. How can I removed any leading spaces from those cells wit
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
I must either be either rather ****ed or need to get my eye sigh
tested but there does not seem to a difference between what you hav
now and what you want
--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...fo&userid=1813
View this thread:
http://www.excelforum.com/showthread.php?threadid=51616