=A1 & ", " & B1 & ", " & C1
to put a space after the comma.
--
Gary''s Student - gsnu200836


"frandk" wrote:

It worked great. I noticed you don't end up with a space after the commas -
is that possible?
--
frandk


"Niek Otten" wrote:

In D1: =A1&","&B1&","&C1
Copy down as far as you need

Copy column D
Select column A
Paste Special, Values
Remove columns B, C and D

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"frandk" wrote in message
...
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