Combine Cells in Excel for Names: Formulas and Steps

To combine a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2 and press Enter; it returns a single name such as Maya Chen. Then fill the formula down the column. This joins the text without merging the cells, so the original names remain available to edit.

What You’ll Need

An Excel workbook with the name parts in separate cells, such as first names in column A and last names in column B.
An empty column for the combined names. Add a heading such as Full Name so it is clear what the new column contains.
Microsoft Excel for Microsoft 365 on Windows for the steps below. The basic formulas also work in Excel for Mac and Excel for the web, though ribbon placement can vary slightly.

Before you begin, check that each person’s name parts are on the same row. For example, A2 and B2 should belong to the same person. If your data has a heading row, put the first formula in row 2 rather than in the heading row. Save the workbook if the source data is important, especially before replacing or rearranging any columns.

Step-by-Step

Identify the name columns. Look at the column letters and confirm which one contains each part of the name. In this example, A contains first names, B contains last names, and C is empty. If your columns are different, use their actual cell addresses in the formula. Avoid inserting a formula over either source column, because that could overwrite a name you still need.
Choose the display order and separator. Decide whether the result should read “Maya Chen,” “Chen, Maya,” or another format. A space is the usual separator between first and last names. A comma and space are useful for a list sorted or presented by surname. Decide this before copying the formula, so every row follows the same convention.
Enter the basic formula. With first names in A2 and last names in B2, type =A2&" "&B2 in C2 and press Enter. The formula joins the value in A2, one space, and the value in B2. If A2 contains Maya and B2 contains Chen, the result in C2 is Maya Chen. The ampersand joins text, while the quoted space supplies the gap between the names.
Check the first result. Compare the result in C2 with the source cells before filling the rest of the column. Confirm that the name is in the desired order and that there is exactly one space between parts. If it looks wrong, correct the formula now rather than copying the error to hundreds of rows. The formula bar shows the formula when C2 is selected; the cell itself displays the result.
Fill the formula down. Select C2 and point to the small square at the bottom-right corner of the cell, called the fill handle. When the pointer changes, drag the handle down to the last row of names. You can also double-click the fill handle when the neighboring source column has a continuous list of entries; Excel will usually copy the formula down to match that list. Check the last few rows to ensure the formula reached the full dataset.
Use a formula that skips missing name parts. If some people have no middle name, or a first or last name may be blank, use TEXTJOIN to place spaces only between nonblank entries. With first, middle, and last names in A2:C2, enter =TEXTJOIN(" ",TRUE,A2:C2) in D2. For Maya in A2, a blank B2, and Chen in C2, the result is Maya Chen, with no extra space. TEXTJOIN is available in Microsoft 365 and newer Excel releases; if your Excel version does not recognize it, use separate formulas or handle the blank rows individually.
Make a surname-first version if needed. With first names in A2 and last names in B2, enter =B2&", "&A2 in C2. If the row contains Maya and Chen, the result is Chen, Maya. Fill it down as above. The comma is part of the quoted text, so Excel displays it literally. This changes only the order in the combined result; it does not sort the records.
Keep the combined names or convert them to fixed text. A formula result changes if either source cell changes. That is helpful when the source names are still being edited. If you need a fixed list—for example, to send it to another system—select the completed results, copy them, and use Home > Paste > Paste Values. This replaces formulas with their current text results. Keep the source columns until you have checked the pasted values, because the formulas will no longer update.
Save and review the column. Scan several names at the top, middle, and bottom of the list. Look for blank results, missing spaces, unexpected punctuation, and names that appear to be paired with the wrong person. Save the workbook after the review. If you intend to remove the original columns, first confirm that the fixed combined names contain everything you need and that no other formulas depend on the source data.

To use a different layout, change only the cell references and separator. For instance, if first names are in D and surnames are in F, use D2 and F2 in the formula rather than moving the data. The row numbers should correspond: a formula in row 2 should refer to that person’s values in row 2. Excel adjusts the row references as you fill down.

Common Mistakes

Choosing Merge & Center instead of joining text. Merge & Center combines the worksheet cells into one larger cell; it does not combine their contents. When several selected cells contain data, merging can keep only the upper-left cell’s content and discard the rest. Use a formula to create a combined name in a separate cell.
Leaving out the separator. A formula such as =A2&B2 joins Maya and Chen as MayaChen. Put a space in quotation marks between the references when you want normal name spacing. For a surname-first display, include both the comma and the space inside the quoted separator.
Putting the formula in the wrong row. If you enter a formula in row 3 but refer to A2 and B2, the displayed name belongs to another record. Make sure the references match the formula’s row before filling down.
Expecting a formula to be permanent text. A formula is linked to its source cells and can recalculate when they change. Use Paste Values if the combined names must stay as they are, and retain a backup or the source columns until you are confident the conversion is correct.
Assuming every name has the same parts. Some people have a middle name, a suffix, multiple surnames, or only one name. A formula with a fixed separator can leave extra spaces when a source cell is blank. Use TEXTJOIN with its ignore-empty option for optional parts, or inspect unusual records separately.

Tips

Use a table for a growing list. If you format the data as an Excel table with Insert > Table, a formula entered in a new table column can be filled through that column automatically. This can also help apply the formula to rows added later. Check the new rows after adding data, particularly if the table’s calculated-column behavior has been changed.
Keep source data intact while building the result. A separate output column makes it easy to compare the joined name with its parts and correct typos. Do not delete the originals simply because the combined column looks right; you may need them for future sorting, mail merges, or updates.
Choose a separator that suits the destination. A regular space works for most readable names. Use a comma and space for “Last, First.” If a receiving system expects a particular format, follow its specification rather than adding punctuation for appearance.
Use a cleanup formula only when needed. With first names in A2 and last names in B2, =TRIM(A2&" "&B2) removes extra ordinary spaces at the beginning and end and reduces repeated ordinary spaces in the combined result. For Maya and Chen it returns Maya Chen. TRIM does not remove every unusual whitespace character, so copied data from websites may need further cleanup.
Keep a clear heading. Label the output column Full Name or Display Name, depending on its purpose. If the list has several name formats, headings such as Full Name and Last, First make the difference obvious to other people using the workbook.

Troubleshooting

The result appears as formula text instead of a name. Check that the cell is not formatted as Text. Change the format to General using Home > Number Format, then select the formula cell, press F2, and press Enter to make Excel evaluate it again. Also check that the formula begins with an equals sign and that Show Formulas is not enabled. On Windows, Ctrl+` toggles formula display; on Mac, the equivalent shortcut is Control+` in many Excel configurations. If your keyboard does not have that key combination, check the Formulas tab for Show Formulas.

There is no space, or there are two spaces. In the formula, make sure the separator is exactly one space between straight double quotation marks. If the source cells already contain spaces at their edges, clean the source values or use the TRIM version described above. A nonbreaking space copied from a webpage may look like an ordinary space but behave differently; retype the affected space or clean the imported data.

The formula returns #NAME? or TEXTJOIN is not recognized. Confirm that the function is spelled TEXTJOIN and that the formula uses commas between arguments. TEXTJOIN is not present in some older Excel editions. If it is unavailable, use the basic ampersand method for rows with all parts present, or build a separate formula for the name patterns in your data. Do not assume an empty-cell-safe result until you have checked it against blank examples.

Only one result appears, or some rows are missing. Check that the fill handle reached the bottom of the data and that the source columns do not have gaps that stopped a double-click fill. Drag the handle manually to the final row if needed. If the result column is filtered, remember that formulas may also exist in hidden rows; clear or review the filter before judging whether the full list was filled.

The wrong person’s name appears. Check that each source row contains the matching parts and that the formula references the same row. Sorting only one column can separate names from their related data. Undo immediately if possible, or restore the original order from a saved copy, then sort the whole table or select the entire data range before sorting.

Frequently Asked Questions

Does combining cells delete the original first and last names?
No. A formula displays a combined result in another cell and leaves the source cells in place. The sources are affected only if you overwrite or delete them yourself. Paste Values changes the formula cells into fixed text, not the original name cells.

Is combining names the same as merging cells?
No. Combining names joins their text into one cell’s result. Merging changes the worksheet layout by making several cells act as one larger cell. For name data, use a formula rather than Merge & Center, because merging can discard values in cells other than the upper-left one.

How do I combine first, middle, and last names when some middle names are blank?
Use TEXTJOIN with a space as the delimiter and TRUE to ignore empty cells. For first, middle, and last names in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) returns Maya Chen when the middle-name cell is empty. Confirm that your Excel version supports TEXTJOIN before using it throughout a workbook.

Can I combine the names without a formula?
Yes. You can copy and paste values into a text editor or construct each result manually, but that is slow and prone to mistakes for a long list. A formula is easier to fill down and update. After checking it, Paste Values gives you a fixed text column without leaving live formulas.

Will the combined name update when I edit the original cells?
Yes, if the result is still a formula and Excel calculation is enabled. A value pasted with Paste Values will not update when the source cells change. Choose formulas for a working list and fixed values for a final export or handoff.

Can I use these steps in Excel for Mac or the web?
Yes. The ampersand and TEXTJOIN formulas work in current Excel for Mac and Excel for the web. The fill handle and Paste Values are available there too, although ribbon labels or locations may differ slightly from Excel for Windows. Keyboard shortcuts can vary by Mac keyboard and Excel settings, so use the ribbon command if a shortcut does not behave as expected.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.