On Sat, 5 Jul 2008 07:09:01 -0700, Teethless mama
wrote:

Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/english/

...then use this formula

=SUBSTITUTE(TRIM(MCONCAT(IF(C2:Z2<"",C2:Z2&" ","")))," ",",")

ctrl+shift+enter, not just enter

Oh, if he can get morefunc, I think this would work as well, and be shorter:

=SUBSTITUTE(TRIM(MCONCAT(C2:Z2," "))," ",",")
--ron