Removing spaces from text

[lj]

I'm in excel and i have a bunch of text data that has an extra space at
the end of the text on the right hand side for each cell. Is there any
easy way to remove this space?

 

[Niek Otten]

Use the TRIM() function.

 

[lj]

I tried using that function but the results still had the spaces. I
used trip and then copy-paste-special values. The result still had the
space. Any other ideas?

 

[lj]

I tried using that function but the results still had the spaces. I
used trip and then copy-paste-special values. The result still had the
space. Any other ideas?

 

[lj]

I tried that and it didn't work (I used trip and then
copy-paste-special-values the data, but the space was still there) any
other ideas?

 

[Peo Sjoblom]

Then you don't have spaces

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[dodong]

Try to use this if you want to clean all the space in cell A4.

=TRIM(SUBSTITUTE(A4,CHAR(32),""))

Regards,
Dodong

 

[Ron Rosenfeld]

I tried using that function but the results still had the spaces. I
used trip and then copy-paste-special values. The result still had the
space. Any other ideas?

Most likely you obtained the values from an HTML document and they are nbsp's
(non-break spaces).

To remove:

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


--ron

 

[davidthegolfer]

Dodong,
Thank you so much for this. Saved me a big problem looking up a 16,00
record file and matching to a 1,560 record list.
Kind regards
David