View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Rhinehart Kevin  Rhinehart is offline
external usenet poster
 
Posts: 3
Default Turning column contents into text list separated by a comma

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.