Need better understanding of TRIM so I can get rid of trailing spa
 

I imported a listof names to creat labels. All columns have trailing spaces.
I have imported some into Word then done a relace it worked but it was a not
the right solution. I understand TRIM in Excel will get rid of Trailing
spaces. The examples HELP gives is not clear to me. Please help me get rid of
these trailing spaces.

Tom

If you want to delete all spaces the just use Edit Replace 'space'
Replace With 'nothing' Replace All

=TRIM(A1) will remove both leading and trailing spaces except a space
between two words. In a convenient column enter =TRIM(your cell) and drag it
down to the end of the list and then Paste Special Values to lose the
formulas.

However if this list you've imported comes from a web site the spaces may
not be ASCII32, CHAR(32) in XL, but could be ASCII160, CHAR(160) in Xl.
This looks like a normal space but isn't so the TRIM function wont find it.

Try highlighting the whole sheet, go Edit Replace Replace What hold
down the Alt key and type 0160 (nothing will appear in the dialogue box)
Replace with 'nothing' Replace All

Regards,
Alan.
"Tom Q" <Tom wrote in message
...
I imported a listof names to creat labels. All columns have trailing
spaces.
I have imported some into Word then done a relace it worked but it was a
not
the right solution. I understand TRIM in Excel will get rid of Trailing
spaces. The examples HELP gives is not clear to me. Please help me get rid
of
these trailing spaces.

Tom