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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you remove trailing spaces withour Trim function? 8
Data cleanup 1
trim leading spaces 10
Getting rid of white space 6
.txt import + saveas + mkdir 3
How do I keep trailing spaces from being trimmed? 2
Simple update 3
Deleting a directory/folder with a trailing space 10

Back
Top