Excel columns problem 1

[benzhaotb]

Hi;
I have one column with customers first names and another column with their last names. Now, I want to put the first name and the last name inside the same column, and only seperate them by a commar in that column. How can I achieve this in Excel?
Thanks very much for your help!

 

[ETID]

If first name is in col A
and Last name is in col B

then in col C type this formula,...and fill down


=a1&","&b1

 

[mbarron]

ETID,
That's so much easier then trying to remember how to spell "concatenate".

I would have used:
=CONCATENATE(A1,",",B1) Mike