delete the extra space at the end of an entry

  • Thread starter Thread starter cpliu
  • Start date Start date
C

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,
 
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
 
Back
Top