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" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed)...

> 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

>