Trim is not removing blank spaces after text.

[Bret189]

I'm trying to clean up my data and I have a cell that says "ABC123 " for example. There must be something unique about those "spaces" as nothing I try can get rid of them. Is there a formula that finds the last letter or number in a cell, then removes anything else to the rest of it? Please note that I might get a cell with "ABC 123 " and I need it to come back as "ABC 123" with only the trailing spaces removed. Thanks!

 

[kweaver]

If the cell is, say, A1, try: =CLEAN(A1)

 

[Mario_R]

Greetings to all.

Sometimes when we copy information from a web page, we come across characters that "look like spaces" (character 32), but are actually '160' characters.

If so, you can try:

=TRIM(CLEAN(SUBSTITUTE(A1, CHAR(160), " ")))

 

[Bret189]

=TRIM(CLEAN(SUBSTITUTE(A1, CHAR(160), " ")))

Thanks, this worked!

 

[Mario_R]

¡Nice!... and thanks.