Don’t miss out on this time-saving Excel hack: How to merge first and last names

Quickly merge first and last names in Excel using concatenate function and simple formula. Check out real examples and detailed instructions to efficiently create a First and Last Name column in Excel spreadsheet!

0
255

Merging two columns in Excel is an important part of data processing. This is usually done to create a column for either First and Last Name or Last and First Name when you have the data separated. In this guide, we will introduce you to two effective methods to perform this task, which include using formulas and concatenate function in Excel. Merging first and last names in Excel will help you save time and work more efficiently when processing data on your computer.

1. Using the concatenate function

You want to create a new column by merging First and Last Name in Excel. To do this, you can use the CONCATENATE formula or the & function in Excel. Here is how to use the CONCATENATE formula:

Step 1: Enter the following formula into cell C2 of the First & Last Name column and press Enter.

=CONCATENATE(A2, ” “, B2)

Merge first and last names in Excel - figure 1

Step 2: Drag the formula down to apply to all rows in the column.

Merge first and last names in Excel - figure 2

With the method of merging first and last names in Excel that you shouldn’t overlook, you can quickly create a list without spending as much time as before.

2. Using formulas

Another way to merge first and last names in Excel that you can apply is to use formulas.

Step 1: Enter the following formula into cell C2 of the First & Last Name column:

=A2 & ” ” & B2

Then press Enter.

Merge first and last names in Excel - figure 3

Step 2: Drag the formula down to apply to all rows in the First & Last Name column.

Merge first and last names in Excel - figure 4

Step 3: This is the final result after completing the process of merging first and last names in your spreadsheet.

Merge first and last names in Excel - figure 5

The above article has guided you on how to merge first and last names in Excel using the concatenate function and formulas in a detailed and easy way. If you find it useful, you can share this article with your relatives and friends to let them know! Good luck with your implementation!

You may also like

What is the CONCATENATE function? How to use the CONCATENATE function in Excel and Google Sheets.

The CONCATENATE function is a highly practical function used to combine text strings or merge the values of multiple cells into one cell in Excel. If you are unfamiliar with how to use the CONCATENATE function in Excel or Google Sheets, follow the content of this article below by FPT Shop.