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

[pinmaster]

Hi, have a look at the TRIM function.

Regards
JG

[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

--

Regards,

Peo Sjoblom


"George" <[email protected]> wrote in message
news:[email protected]...
> 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

[George]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[Ardnas]

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 !!??

[MrShorty]

Help file for the TRIM() function notes two different kinds of space character: https://support.office.com/en-us/art...rs=en-US&ad=US

Ardnas: This forum is pretty strict about not posting your question in another user's thread. If that doesn't answer your question, start your own thread. You can link back to this thread if you feel that it helps you explain your question/problem.