A similar question was asked & answered in the same newsgroup this morning.
That post was titled "Function to concatenate cells in a range":
http://www.microsoft.com/office/comm...c-06cc48cff765
Paste the function code provided by Jacob in a general VBA module in your
workbook. If you are new to user-defined functions (macros), this link to Jon
Peltier's site may be helpful:
http://peltiertech.com/WordPress/200...e-elses-macro/
Hope this helps,
Hutch
"MaggieB." wrote:
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!