How do I delete spaces from the end of text

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

Hi, have a look at the TRIM function.

Regards
JG

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" <George@discussions.microsoft.com> wrote in message
news:183AF579-A860-4D66-AFF8-892ED921300D@microsoft.com...
> 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

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" <George@discussions.microsoft.com> wrote in message
> news:183AF579-A860-4D66-AFF8-892ED921300D@microsoft.com...
> > 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
>
>
>

TRIM, or TRIM(SUBSTITUTE) .... etc is not working. Which cell do you put the formula in.

I created a new column next to the one I want to trim and put the formula in the empty cell next to it, but referring to it??? Blank space at the end still remains !!??