Look at HELP for the TRIM worksheet function.
--ron


"...or multiple embedded space characters ..."

thanks a lot I would never imagine that TRIM formula works in a
different way than a VBA function.

Thank you :)