How do I delete spaces from the end of text

[George]

Some of the text fields that I have to clean up have a space (or more than
one space). I need to clean this text up so the last word is the end of the
text string.

Any ideas?

Thanks

 

[Peo Sjoblom]

Id the text copied from the web, in that case you might have trailing html
characters, if not us

=TRIM(A1)

otherwise

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

if there are many see:


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

 

[George]

Very helpful. Thanks again.

Id the text copied from the web, in that case you might have trailing html
characters, if not us

=TRIM(A1)

otherwise

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

if there are many see:


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

--

Regards,

Peo Sjoblom

 

[pinmaster]

Hi, have a look at the TRIM function.

Regards
JG

 

[vee]

What if the space appears to be at the front?? I copied some data, and i
have to go cell-by-cell and delete out the first space (but there doesnt seem
to be a space) to make a formula work that is referring to that cell??

Thanks! Veronica