One way:

http://www.mcgimpsey.com/excel/udfs/multicat.html

In article . com,
"Kevin Rhinehart" wrote:

Hi,
I have a single column of band names, that I would like to turn into
text separating each band by a comma and a space

ie:

I want to turn this

A Tribe Called Quest
Amboy Dukes
Art Brut
Bad Brains
Bauhaus

Into this

A Tribe Called Quest, Amboy Dukes, Art Brut, Bad Brains, Bauhaus

Is there an easy way to do this?

Thanks.