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

Trim should work, Tom, but it's tough to say without seeing your data. What
happens if you open the data directly from Excel? What format is it now? Any
txt file opened from Excel should give you delimiter options. Are the number
of trailing spaces always different? Are the trailing spaces providing
fixed-width as a text file?
************
Anne Troy
www.OfficeArticles.com

"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