Home

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? 

Example:

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

 

Thanks for your help. 

4 Replies
Highlighted

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
11 Replies
Auto-Add new employees
Mathias Koprek in Microsoft Teams on
14 Replies
Getting Started - Creating a team accross two tenants
bw-ipim in Microsoft Teams on
40 Replies