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

How do I delete spaces from the end of text
 

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

How do I delete spaces from the end of text
 

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

How do I delete spaces from the end of text
 

Hi, have a look at the TRIM function.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493960

How do I delete spaces from the end of text
 

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

"pinmaster" wrote:


Hi, have a look at the TRIM function.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493960