In D1 enter:
=A1 & "," & B1 & "," & C1 and copy down

Then, if you wish, copy column D and paste/special/value back onto column A
--
Gary''s Student - gsnu200836


"frandk" wrote:

I have a simple customer data worksheet. Column A - Customer Name, B - City,
C-State. My boss wants Column A to have the customer Name, City, State. How
do I merge the information into one column with commas seperating the info?
I know I can cut and paste but there are about 600 names and I don't have all
day!
--
frandk