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
Problems with formating text within a cell.
Maciej Fox in Excel on
10 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Giant stupid numbers
Headaking in Excel on
4 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies