Hi,

You may download and install this addin -
http://www.download.com/Morefunc/300...-10423159.html

Now use the mconcat(range) function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"mh" wrote in message
...
I would like to combine the words from different cells into one cell -
sometimes 1 or 2 cells are left empty

Example
A1 A2 A3 A4 A5
Peter Simon Derek Empty Kent

combine into one cell marking all
=A1&","&A2&","&A3&","&A4&","&A5

Should say
Peter, Simon, Derek, Kent (without extra , or space for empty cell
included)

Could somebody help me with formula for this? would be greatly appreciated