On 26 Sep 2006 05:50:38 -0700, "Morris" wrote:



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 :)

VBA and Excel are really two different products. There are other functions
(e.g. Round) which also work differently in the two programs.
--ron