Merging cells into single cell separated by commas in excel.?

I have a column of 25 names. I want to combine them into a single cell separated by commas. I know about the =(A1&","&A2) function, but how can I use that (or something else) for a whole range?
3 answers 3