How to combine First and Last Name in Excel

Programming Windows

 

In Excel, you can have a column with a first name and a column with a last name that you want to concatenate. In this tutorial, I will explain how you can easily do this.

Suppose we have a list of names in column A and a list of surnames in column B, and we want to concatenate them in column D. We will need to use Excel CONCAT function to do this.

The CONCAT function that accepts a list or range of text strings and concatenates them (or combines them) to create a new continuous value. So it basically allows you to combine the information in two columns into one new column.

How to use CONCAT in Excel

In the first cell of column D, we write =CONCAT(A1, " ", B1). Here is the syntax to create a new string including the first name (A1), followed by a space (" "), then the last name (B1).

So instead of having “Harry” and “Potter” in two different cells, Excel will give us a new column with “Harry Potter” as we want.

If you want to apply this formula to multiple rows, you can copy this formula and paste it into all the cells below. Or you can click the green handle in the bottom right corner of the cell and drag it to make a green border surround all the cells where we want to apply this formula. When you publish, Excel will apply CONCAT for all the boxes you have checked.

figure-87

CONCAT compatibility issues

The CONCAT function was added in Excel 2016. So if you use previous version of Excel you need to use CONCATENATE instead of.

It has some slight differences, but for this case you can follow the instructions above and just replace CONCATENATE live whenever CONCAT was used and it should give you the same result.

picture-88

Inference

In this tutorial we learned about Excel CONCAT works alongside its predecessor, CONCATENATE. We used this function to combine a list of first and last names together to get a list of full names.

Hope this helps!

Source link

Share: