Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim Function | Excel Worksheet Functions | |||
Trim and Keep the Trimmed Data | Excel Worksheet Functions | |||
Excel TRIM() can't handle in pasted HTML | Excel Discussion (Misc queries) | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
How to use TRIM function | Excel Worksheet Functions |