How to combine one character of a cell with text from another cell in Excel

Darla Nice
New Contributor

We are trying to take the first letter of the first name in column A and combine it with the last name in column B.  We need this to be in a formula form and not just using text to column or flash fill.  Is there a formula we can use for this? 


Mary (cell A1) Smith (cell B1) combine to cell C1 as MSmith


Thanks for your help. 

4 Replies

No problem, glad it worked :)


You might also have a look at right() and mid() they do similar things for the right and middle of a text string.

Related Conversations
Teams - Chat History
David Gorman in Microsoft Teams on
8 Replies
Remove MS shifts schedule from a Channel in MS Teams
John Crook in Microsoft Teams on
17 Replies
Move Channels between Teams
HerculesConsen in Microsoft Teams on
13 Replies
Auto-Add new employees
Mathias Koprek in Microsoft Teams on
14 Replies
Configuring more than one account in MS-Teams
Biju_Radhakrishnan in Microsoft Teams on
15 Replies