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