MS Excel text handling question?

Question

I want to combine text strings from different cells to create a new string:

A              B           C
1   John          Doe      John Doe
2.   Mary         Roe      Mary Roe

I know there's a way, did it years ago; something like "A1"+"B1" as the formula for C1.

Joshua · Answer

You're looking for the function concat. If you want to joint the text from A1, B1, and C1 (lets say), it would be 
=CONCAT(A1, B1, C1)
Though keep in mind that the function does not add spaces, and so you will need to add a space after each cell youre joining together.

MS Excel text handling question?

Trending Questions