How to Combine First and Last Names in Excel (CONCATENATE)

The Data Entry Nightmare

If you work in human resources, sales, or event management, you will inevitably receive a spreadsheet where the data is formatted incorrectly for your specific needs. The most common scenario is receiving a list of hundreds of employees where the “First Name” and “Last Name” are separated into two entirely different columns.

If you need to upload this list into an email marketing platform or print out name badges for a conference, you need the full name in a single cell. Doing this manually by copying and pasting 500 names is not just tedious; it is a massive waste of time and highly prone to human error.

Fortunately, Microsoft Excel was built specifically to solve data formatting problems like this. You can instantly merge the text from two different columns into a single cell using a simple mathematical formula. You just have to tell Excel exactly how to stick the words together.

Method 1: Using the Ampersand (&) Symbol (The Quickest Way)

You do not need to memorize complex, multi-word formulas to merge text. You can simply use the ampersand symbol (&) to tell Excel to join two cells together.

Let’s assume you have a spreadsheet where Column A contains first names (e.g., cell A2 says “John”) and Column B contains last names (e.g., cell B2 says “Smith”). You want the full name to appear in Column C.

1. Click on the empty cell where you want the full name to appear (e.g., cell C2).
2. Type an equals sign (=) to tell Excel you are starting a formula.
3. Click on the cell with the first name (A2).
4. Type an ampersand (&).
5. Type a quote mark, a space, and another quote mark (” “). This is the secret to the entire process. If you skip this step, Excel will merge the names into “JohnSmith”. You must explicitly tell Excel to insert a blank space between the two words.
6. Type another ampersand (&).
7. Click on the cell with the last name (B2).
8. Your final formula should look exactly like this: =A2&" "&B2
9. Press Enter.

Cell C2 will now display “John Smith” perfectly.

Method 2: Using the CONCATENATE Function (The Formal Way)

If you are merging three, four, or five different columns of data (for example, adding a middle initial and a job title), typing out a dozen ampersand symbols can get visually confusing. In these scenarios, you should use Excel’s built-in CONCATENATE function (or simply CONCAT in newer versions of Excel).

Using the same example as above:

1. Click on cell C2.
2. Type =CONCATENATE(
3. Click the first name cell (A2).
4. Type a comma (,).
5. Type your spacer (” “).
6. Type another comma (,).
7. Click the last name cell (B2).
8. Type a closing parenthesis ()).
9. Your final formula should look like this: =CONCATENATE(A2, " ", B2)
10. Press Enter.

How to Apply the Formula to 500 Rows Instantly

Now that you have successfully merged the first and last name for John Smith in row 2, you do not need to manually type out the formula for the other 499 employees on your list.

1. Click once on cell C2 (the cell with the successful formula).
2. Look at the bottom-right corner of the green border surrounding cell C2. You will see a tiny, solid green square. This is called the Fill Handle.
3. Hover your mouse cursor exactly over that tiny green square. Your cursor will change from a thick white cross to a thin black plus sign (+).
4. Double-click your left mouse button rapidly.

Excel will instantly copy your formula, adapt the row numbers automatically (changing A2 to A3, A4, etc.), and fill the entire column all the way down to the bottom of your dataset. You have just merged 500 names in less than three seconds.

Important Final Step: Removing the Formula

Right now, your new “Full Name” column relies entirely on the original data. If you delete Column A or Column B, your new Column C will break and display a #REF! error.

To safely delete the original columns, you must convert your new formulas into plain, static text.

1. Highlight your entire new “Full Name” column (Column C).
2. Press Ctrl + C to copy the entire column.
3. Right-click on the C at the very top of the column.
4. Under the “Paste Options” menu, look for the icon that shows a clipboard with the numbers 123 on it. This is the Paste as Values button.
5. Click it.

You have now stripped the mathematical formulas out of the cells, leaving only the permanent text (“John Smith”). You can now safely delete the original First Name and Last Name columns without destroying your spreadsheet.