Excel Question

[jalenben1]

Last Name* First Name*
ABITBOL ARGIE
ADAMS ROBERT
AGUIAR TERESA
AGUILAR FERNANDO
AINSWORTH DEDRA


I have two columns - Last Name and First Name. I want to combined the two columns and have the names read as follows: Abitol,Argie. How would I do that?

 

[SkipVought]

Hi,

Either use the Concatenate function or & concatenation operator, in column C...
[tt]
=A1&","&B1
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}