delete the extra space at the end of an entry

[cpliu]

It seems the same text with an extra space is considered as a
different text when using formulas. I need to get rid of the space,
but if I search by "text example here ", I get "text example here" (no
space at the end).

Is there a quick way to get rid of the space for each cell?

thanks,

 

[Gord Dibben]

The TRIM function removes extra spaces.

In a helper cell =TRIM(cellref)

Or it may be the dreaded non-breaking space which TRIM and CKEAN won't see.

In that case, select the data and Edit>Replace

What: Alt + 0160 (typed on the numpad)

With: nothing


Gord Dibben MS Excel MVP