combining text in cells

%3CLINGO-SUB%20id%3D%22lingo-sub-377646%22%20slang%3D%22en-US%22%3Ecombining%20text%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377646%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20cells%20one%20for%20first%20name%20and%20one%20for%20last%20name%2C%20I%20want%20the%20third%20cell%20to%20show%20the%20first%20initial%20of%20their%20first%20name%20followed%20by%20their%20last%20name.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE.g.%20Nancy%20Kelleher%20becomes%20NKelleher%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-377646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377664%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20text%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377664%22%20slang%3D%22en-US%22%3EWelcome!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377663%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20text%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377663%22%20slang%3D%22en-US%22%3EBrilliant%20-%20thank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377654%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20text%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377654%22%20slang%3D%22en-US%22%3EIf%20A1%3AB1%20contains%20the%20first%20and%20last%20names%2C%20respectively%2C%20the%20formula%20in%20C1%20is%3A%3CBR%20%2F%3E%3DLEFT(A1)%26amp%3BB1%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted
If A1:B1 contains the first and last names, respectively, the formula in C1 is:
=LEFT(A1)&B1
Highlighted
Brilliant - thank you
Highlighted
Welcome!