Very helpful. Thanks again.

"Peo Sjoblom" wrote:

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


"George" wrote in message
...
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