View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Samuel Samuel is offline
external usenet poster
 
Posts: 26
Default 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?