how do I remove empty spaces trailing a text string?

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!

Have you tried using the 'TRIM' formula? If cell A2="00014C " then in
another cell type: =trim(A2) and you should get "00014C". This will work
even if the spaces are preceeding the field values. Then to save the value,
just copy the trim cell(s), select 'Paste Special...', and select under
'Paste' select 'Values'.

Hope this helps.


"Need_Help" wrote:

> 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!

"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" <[email protected]> wrote in message
news:[email protected]...
> 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!