How to combine three columns information
Thank you Thank you- Both of you.
--
frandk
"Gary''s Student" wrote:
=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
|