Q: Deleting the last character from text fields in excel [Us@ cod@ to @-mail m@]

[S.V.Proff]

I have a bunch of text with a trailing blank.

How can I get rid of them?

In MS word there is the ^p to indicate the end of the line.

Is there something like this in Excel?

Thanks!

Sam

(Post your replies here. My e-mail is spam proofed unless you use a code)

 

[mzehr]

Hi, S.V.
Short of going to VBA, have you tried to insert a helper
column and use the trim function?

HTH

 

[Doug Kanter]

You could try the CLEAN function: "Removes all nonprintable characters from
text"
or
the TRIM function: "Removes all spaces from a text string except for single
spaces between words"

 

[Peo Sjoblom]

TRIM in this case if it is spaces, CLEAN won't do anything about spaces,
none of them work if they are trailing html characters, then the OP would
need

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

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom

 

[S.V.Proff]

Thanks guys.

TRIM in this case if it is spaces, CLEAN won't do anything about spaces,
none of them work if they are trailing html characters, then the OP would
need

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

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom