Hi,

to remove unwanted space in cell A1, for example

=TRIM(A1)

Copy down as necessary. Then copy all the formulas, and choose Edit, Paste
Special, Values. You can then remove the originals and keep the clean
version.


--
Thanks,
Shane Devenshire


"dstiefe" wrote:

I have a column full of names...the problem is there is random spacing before
the name...for example: " name" and in others it may be " name" while
others are " name"

how do I first count the number of spaces? then delete them so the name is
at the far left?

thank you