Creating a list from range of cells

[gene expression dude]

Hi, I have a column of cells, each containing a text value.

I want to put all those value into the same cell, separated by commas.

Concatenate won't do it, as it smushes all the words together into a long strong of gobbledygook.

Any ideas?

Thanks in advance.

[shg]

=a1 & "," & a2 & "," & ...

[darkyam]

Easiest formula way to do it is putting this in B2, assuming your list begins in A1: =A1&", "&A2, and then, in B3: =B2&", "&A3 copied down as needed. The last cell would have the result you're looking for.

[tom1977]

try this:

Please Login or Register  to view this content.

your list of text cells should be in column A