Text extraction and re-combination

[slittlepage]

If I have one column with first names and another one with last names (Example, Aaron and Leeper), is there a way to extract the first letter of the first name (A) and add it to the entire last name (leeper) and get the result in another column (aleeper)?

Thanks for your help
Susan Littlepage

[Wagstaff]

Hi,

Assuming First name in col A and Last name in col B you could enter the formula below in col C

=CONCATENATE(B1,LEFT(A1,1))

Wagstaff