View Single Post
  #1  
Old June 3rd, 2010, 06:17 PM posted to microsoft.public.excel.worksheet.functions
MaggieB.
external usenet poster
 
Posts: 1
Default Large list of numbers to concatenate

I have a list of 600+ zip codes that are curently in individual cells. I need
to turn them into one list separated by commas. Is this possible? The best
solution I can think of is
=concatenate(A1, ", ",B1)

However, is there a way to automate this instead of individually typing this
in for all 600+ cells?

Thanks!