Aug 15 2018 02:02 PM
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.
Aug 15 2018 02:09 PM
=left(A1,1) & B1
Aug 16 2018 06:34 AM
Thank you so much!
Aug 16 2018 07:27 AM
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.
Aug 16 2018 02:47 PM
Bit shorter
=LEFT(A1) & B1