entire column to comma delimited cell
 

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?

entire column to comma delimited cell
 

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

entire column to comma delimited cell
 

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

Thanks for the tip.

"Sheeloo" wrote:

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