entire column to comma delimited cell

S

samuel

I have a column of data A1:A156

I want to take each value and place in C1

Where C1 would look like:

A1&", "&A2&", "&A3&", "&A4 ....etc

I assume I will need a macro to accomplish this?
 
S

Sheeloo

One way to do this is to
enter =A1 in B1
enter =B1&", "&A2 in B2
copy down till B156
enter =B in C1

B can be any unused column in your spreadsheet and may be hidden later or
you can do paste special in C1 the value in B156 and delete
 
S

samuel

I would have never thought to do it that way, but works great.

Thanks for the tip.
 
Top