Hi
see:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards
Frank Kabel
Frankfurt, Germany

"carl" schrieb im Newsbeitrag
...
Is there an eay way to remove spaces in a range of cells ?

Thank you in advance.