The fastest way: use the ampersand (&) to join two columns

Open your spreadsheet. Put your first names in column A and last names in column B. Click on an empty column — say, column C — and click on the first cell where you want the combined name to appear.

Type this formula: =A1&" "&B1. The ampersand (&) tells Excel to join the text from A1, a space in the middle, and the text from B1. Press Enter. Excel will show you the combined name in that cell.

Now copy that formula down to every row that has data. Click the cell with your formula, then drag the small square at the bottom-right corner of the cell down to the last row. Excel will automatically adjust the row numbers for each line — so row 2 becomes =A2&" "&B2, row 3 becomes =A3&" "&B3, and so on.

Key Takeaways

  • The ampersand (&) formula =A1&" "&B1 joins text from two cells with a space between them.
  • After you type the formula once, drag it down to copy it to every row with data — Excel adjusts the row numbers automatically.
  • If you want to keep only the combined names and delete the original columns, copy the results and paste them as values first.
  • The CONCATENATE function does the same thing as the ampersand but uses more typing: =CONCATENATE(A1," ",B1).

Turning the formula into actual text you can keep

The formula you just made is live — it points back to the original first and last name columns. If you delete those columns later, your combined names disappear too. To make the combined names permanent, you need to convert the formula to plain text.

Select all the cells with your combined names. Copy them (Ctrl+C on Windows, Command+C on Mac). Right-click and choose "Paste Special". A dialog box will open. Click the "Values" option and then OK. Now those cells hold the actual text, not a formula, and you can safely delete the original columns.

Handling names with extra spaces or blank cells

Sometimes your data is messy. A first name cell might have extra spaces before or after the text. A last name cell might be completely empty. When you use the ampersand formula on messy data, you end up with results like "John Smith" (two spaces) or "John " (a trailing space).

To clean this up, wrap each cell reference in the TRIM function: =TRIM(A1)&" "&TRIM(B1). TRIM removes extra spaces from the beginning and end of text. If a cell is blank, TRIM leaves it blank, so you might still get "John " if the last name is missing — but at least you won't have double spaces.

If you want to skip the space entirely when a name is missing, use an IF statement: =IF(B1="",A1,A1&" "&B1). This says: if B1 is empty, just use A1; otherwise, join them with a space. It takes longer to type, but it handles gaps in your data more gracefully.

Using CONCATENATE if you prefer a different syntax

CONCATENATE is an older Excel function that does exactly what the ampersand does. Instead of =A1&" "&B1, you write =CONCATENATE(A1," ",B1). The result is identical. Some people find it easier to read; others find it slower to type.

In newer versions of Excel, there is also a CONCAT function (shorter) and a TEXTJOIN function (more powerful). TEXTJOIN lets you join multiple columns and skip blank cells automatically: =TEXTJOIN(" ",TRUE,A1:B1). The TRUE tells it to ignore empty cells. For most people, the ampersand is still the simplest choice.

What to do if the names are already in one column

If your data is backwards — all names are already combined in one column and you need to split them — you will need different tools. Excel has a "Text to Columns" feature under the Data menu that can split a column at a space, comma, or other character. That is a separate process from merging.

If you have a column like "John Smith" and you want to split it into first and last, select the column, go to Data > Text to Columns, choose "Delimited", select "Space" as the delimiter, and click Finish. Excel will split the column into two. This only works cleanly if names are always in the same format — first name, space, last name, nothing else.

Combining more than two columns

You can join more than two columns the same way. If you have first name in A, middle name in B, and last name in C, use: =A1&" "&B1&" "&C1. Add as many ampersands and column references as you need. You can also add punctuation: =A1&" "&B1&", "&C1 would give you "John Michael, Smith" if that is the format you want.

With TEXTJOIN, you can join a whole range at once: =TEXTJOIN(" ",TRUE,A1:C1). This joins columns A, B, and C with spaces between them and skips any blank cells. It is cleaner if you have many columns or if some cells are empty.

Frequently Asked Questions

What if I have a suffix like Jr. or III in a separate column?

Add it to your formula the same way: =A1&" "&B1&" "&C1 (if A is first name, B is last name, C is suffix). Or use TEXTJOIN: =TEXTJOIN(" ",TRUE,A1:C1). If the suffix column is sometimes empty, TEXTJOIN handles that automatically; with the ampersand, you will get extra spaces.

Can I undo this if I make a mistake?

Yes. Press Ctrl+Z (Windows) or Command+Z (Mac) when ready after you paste or copy. If you have already closed the file, you cannot undo. That is why converting formulas to values is important — once you do that, the original columns are safe to delete.

Why does my combined name have extra spaces?

Your original data probably has trailing spaces. Use TRIM: =TRIM(A1)&" "&TRIM(B1). If a name cell is completely blank and you are using the ampersand, you will get a space with nothing on one side. Use IF or TEXTJOIN to skip blank cells instead.

Is there a way to do this without a formula?

Not in Excel itself. You could copy the data into Google Sheets and use the same formula, or use a text editor to manually combine names, but that defeats the purpose of using a spreadsheet. The formula takes 30 seconds to set up and works on thousands of rows.

What happens if I delete the original columns before converting the formula to values?

Your combined names will show #REF! errors because the formula cannot find the columns it is pointing to. If this happens, undo when ready (Ctrl+Z). If you cannot undo, you will have to re-enter the original data or restore from a backup.