How to combine last and first name in Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-combine-last-and-first-name-in-Excel.png)
Excel offers a very interesting way to combine last and first name. We can cater to this problem statement by using the “=CONCATENATE()” formula. We can perform the below mentioned way to combine last and first name in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with first and last name
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-combine-last-and-first-name-in-Excel.png)
– Open the desired Excel workbook containing multiple cells with first and last names which can be combined
Step 2 – Using the formula
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-combine-last-and-first-name-in-Excel.png)
– Now type the concatenate formula and add the first cell (in our case it is cell “B6”). Now add a comma (,) and then add “ “ followed by a comma and then add the other cell to the formula and then hit Enter as shown in the image above.
Step 3 – Cells combined
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-combine-last-and-first-name-in-Excel.png)
– We can see that the cells have been combined with first and last names