"ASAP Utilities", a free add-in from www.asap-utilities.com includes this as
one of it's standard features.

Vaya con Dios,
Chuck, CABGx3



"Need_Help" wrote in message
...
I have a column with multiple length item numbers and some of the cells
contain "spaces" following the number, i.e. "00014C ". This example
shows
that there are 6 text characters plus 4 spaces, I can get rid of the
spaces
easily for this example, but when i have a column with thousands of rows
each
with different number of text characters and different number of spaces,
it's
hard to do. Please help!