Turning column contents into text list separated by a comma

K

Kevin Rhinehart

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text string separated by comma 6
Going from column to comma separated list... 1
Separating a comma separated list 3
How can I extract the first & last name separated by a comma 5
how to export a column as text separated by comma? 5
Joining the contents of several cells into a single one 6
Extracting text separated by | from string? 3
Transforming data in column into a linear text string 2

Top