Let’s say, You may have thousands of data with first and last names in excel and then your boss demands to join them in a new column and you scratch your heads and ask yourself “how tf? 🙄”, well we covered it for you 😎
An easy way to join the first and last name in excel is to follow these steps:
We have taken an example above which shows first name as well as the last name of all the F.R.I.E.N.D.S. show characters (ignoring the middle name).
Now if we want to bring the first and last name together, here’s what we will do:
Always remember, to bring a solution you have to put the “equal to” sign first.
After putting the sign, we will select the first name, i.e. Chandler (cell B3).
Then we will put the sign of and i.e. &.
Then we will jot down “ “.
Please note, that there is space between the quotation marks, if you do not put space between the quotation marks then your end result will come as ChandlerBing and not Chandler Bing.
So, be careful at this step.
Now again put the sign of and i.e. & then select the last name i.e. Bing (cell D3).
Press “enter”. And you will get your answer right on the screen!
Chandler Bing (one hell of a character!!!)
Now take your cursor to the bottom right corner of your result and drag it down. It will make your work easier. Now you don’t have to write the formula again and again for every name.
It’s easy, isn’t it?