Have 300 cells, want them in one, seperated by comma

Hey guys,
I think this is a really easy question but I can't seem to think of an easy answer. I have 300 cells in one column I want to have combined into one cell, seperated by commas. I know I could just =A1&","&A2&","&... but this is not what I want to spend my afternoon doing. Is there a better way of doing this?

Thanks in advance for your help!
Adam

If your data is in A1:A300, then in B1 put the formula

=A1

In B2 put the formula

=B1&","&A2

Fill that down to B300. In B300 you'll have your list of all values from A1:A300 separated by commas (up to the cell character limit, of course).

ther are several variants of this but this will take selection an put it in b1
change b1 to where you want it

Please Login or Register  to view this content.