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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies