How to combine three columns information

[frandk]

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!

 

[Gary''s Student]

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

Then, if you wish, copy column D and paste/special/value back onto column A

 

[Niek Otten]

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

 

[frandk]

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

 

[Gary''s Student]

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

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

 

[frandk]

Thank you Thank you- Both of you.
--
frandk

=A1 & ", " & B1 & ", " & C1
to put a space after the comma.