Spacing

[Luc Vandenhoeck]

Hi
Trim removes spacing in the beginning and end of word.
How can i delete a spacing betwee two words (name) ex "De Wit" > i want
"dewit"
THX Luc

 

[Dave Peterson]

You can use:
=substitute(a1," ","")
to remove all the spaces (leading/trailing/embedded)

or

=lower(substitute(a1," ",""))
if you really wanted lower case.

 

[Alan]

=SUBSTITUTE(A1," ","")
Regards,
Alan.