Trim Function

[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.

 

[Alan]

Hi,

=SUBSTITUTE(A1," ","")

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

Regards,
Alan

 

[Gord Dibben]

Yew

Edit>Replace

what: space
with: nothing

Replace All.

Gord Dibben Excel MVP - XL97 SR2 & XL2002