Trim Function

  • Thread starter Thread starter Yew Keong
  • Start date Start date
Y

Yew Keong

As I understand it, the Trim function leaves a space
between two words. However, I would like to leave no
space at all between the words. For example, I want SVGG
334XK (with a space in between) to be SVGG334XK.

Anyone can help?

Thank You.
 
Hi,

=SUBSTITUTE(A1," ","")

or probably easier, use Edit > Replace, hit the space bar in "Find What" and
leave "Replace With" empty

Regards,
Alan
 
Yew

Edit>Replace

what: space
with: nothing

Replace All.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top