Spaces after every Name in Column

[Critx]

I recently bought a database with names, addresses, cities, etc. and after EVERY single one of the names, cities, and addresses, there is 10+ spaces after the data. I cannot get the TRIM function to work for more then one Cell on excel 2013, I am trying to adjust thousands of cells of information to put onto envelopes, I will give an example of what it shows up when I use the data and put it on an envelope

DOE ,JOHN F
555 Street Name
Chicago , IL 60652

[protonLeah]

You need to post a sample workbook with a few rows. The trailing characters might not be "spaces" there are others that don't show up.
To attach a Workbook

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[flextera]

=IFERROR(TRIM(IF(LEN(VLOOKUP(F7, Sheet2!$A$1:$B$10000, 2, FALSE))>0,SUBSTITUTE(VLOOKUP(F7, Sheet2!$A$1:$B$10000, 2, FALSE), ” “, “”),””)), “”)


Use this formula as needed.

[Sam Capricci]

just trying with dummy data, maybe find " *" that is 2 spaces and an asterik and replace with one space? Worked on my test data.