Forum Discussion
Nancy_Kelleher1
Mar 20, 2019Copper Contributor
combining text in cells
I have two cells one for first name and one for last name, I want the third cell to show the first initial of their first name followed by their last name.
E.g. Nancy Kelleher becomes NKelleher
3 Replies
Sort By
- TwifooSilver ContributorIf A1:B1 contains the first and last names, respectively, the formula in C1 is:
=LEFT(A1)&B1- Nancy_Kelleher1Copper ContributorBrilliant - thank you
- TwifooSilver ContributorWelcome!