Forum Discussion
How to combine one character of a cell with text from another cell in Excel
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 fi...
=left(A1,1) & B1
Thank you so much!
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.