To merge first, middle, and last names stored in A2, B2, and C2, enter =A2&" "&B2&" "&C2 in D2. The result is one name, such as Ava Marie Chen. You can then copy the formula down to combine the names in the other rows. This method keeps the original cells unchanged and works in Microsoft Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook with the three parts of each name in separate columns, for example first name in column A, middle name in B, and last name in C.
- An empty column where you can place the combined names. In this guide, the output goes in column D.
- Excel for Microsoft 365 on Windows. The basic formula also works in other recent desktop versions of Excel and Excel for the web.
Before starting, check that the three name columns are in the same order for every row. If your data has no middle names, or if some middle-name cells are blank, use the spacing option later in the guide to avoid unwanted extra spaces.
Step-by-Step
- Check the columns and choose an output column. Look at a few rows to confirm which column contains each name part. For this example, A contains the first name, B contains the middle name, and C contains the last name. Column D is empty and will hold the combined result. If your worksheet uses different columns, you can adapt the cell references in the formula. Keep the original columns in place until you have checked the merged names.
- Select the first output cell. Click D2, the cell on the same row as the first set of names. Do not enter the formula in D1 if row 1 contains column headings. Starting in D2 keeps the result aligned with the names on row 2.
- Enter the formula with spaces between the names. With first, middle, and last names in A2, B2, and C2, enter
=A2&" "&B2&" "&C2in D2 and press Enter. The ampersand joins text, while each pair of quotation marks around a single space inserts a space between name parts. For instance, if A2 contains Ava, B2 contains Marie, and C2 contains Chen, D2 displays Ava Marie Chen. The formula does not change the values in A2:C2. - Check the result before copying it. Compare D2 with the three source cells. Make sure the name parts appear in the right order, are spelled correctly, and have spaces between them. If the formula appears as text rather than producing a name, check the troubleshooting section below before filling the formula down.
- Copy the formula to the other rows. Click D2 again. Move the pointer to the small square at the lower-right corner of the cell, called the fill handle, and drag it down to the last row containing names. Excel adjusts the references for each row: the formula in D3 refers to A3, B3, and C3, for example. If the name data is next to the output column and there are no gaps, double-click the fill handle to fill down alongside the data. Check the last few results, especially if the source list has blank rows.
- Use Fill Down as an alternative. You can select D2 and the remaining destination cells, then choose Home > Fill > Down. On Windows, Ctrl+D is the Fill Down shortcut; on Mac, use Command+D. Enter the formula in the top cell of the selected range before using Fill Down. Excel copies that top formula through the selected cells and adjusts the row references.
- Fix extra spaces if some name parts are blank. The basic formula inserts a space for every separator, even when a source cell is empty. With first, middle, and last names in A2:C2, use
=TRIM(A2&" "&B2&" "&C2)in D2 instead if the middle name may be missing. TRIM removes spaces at the beginning and end and reduces repeated regular spaces between the remaining text. For example, Ava in A2, a blank B2, and Chen in C2 become Ava Chen rather than Ava followed by an extra gap and Chen. Fill this formula down in the same way. - Optionally use a formula that skips empty cells. With the first, middle, and last names in A2:C2, enter
=TEXTJOIN(" ",TRUE,A2:C2)in D2 to join the non-empty cells with one space between them. TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. The TRUE argument tells it to ignore empty cells, which is useful when middle names are often missing. Copy it down and confirm that each row’s result is correct. If you use an older Excel version without TEXTJOIN, use the TRIM formula instead. - Decide whether to keep formulas or save fixed text. Keep the formulas if you expect to edit the source names and want the combined result to update automatically. If you need a fixed list, select the completed results in column D, copy them, and choose Home > Paste > Values to replace the formulas with their current displayed text. Do this only after checking the results. You can then remove the original columns if they are no longer needed, but save a copy of the workbook first if you may need to refer back to them.
On Excel for Mac, the formulas and ribbon steps are essentially the same, though some ribbon labels or placements can vary slightly by release. Excel for the web also supports the basic concatenation formula and fill handle. The keyboard shortcut for Fill Down differs by platform as noted above.
Common Mistakes
Leaving out the quotation marks around the space. A formula that joins A2, B2, and C2 without inserting spaces can return AvaMarieChen. Include a separator such as a quoted space between the cell references. The quotation marks tell Excel that the space is text to add, rather than part of a cell address or function.
Using the wrong row number. If you put a formula referring to A2:C2 in a destination cell on row 3, it will return the names from row 2. Start the formula in the same row as the source names. When you fill down from that cell, Excel will update the row numbers automatically.
Putting the result in a source column. If you enter the formula in A2, B2, or C2 while it refers to that same cell, Excel may report a circular reference. Choose a separate destination column, such as D, so the formula reads the source cells and writes the result somewhere else.
Assuming every person has a middle name. The simple formula still inserts separators when a cell is empty, which can make the result look as if it has extra spaces. Use TRIM around the joined text or TEXTJOIN with its ignore-empty argument set to TRUE.
Expecting a formula to correct the name data. Combining cells does not identify misspellings, switch first and last names, or remove unwanted punctuation. Review the source cells and the output. For example, if the last name is in column B and the middle name is in C, change the references to match your actual layout.
Deleting the source cells too early. A formula depends on the cells it refers to. If you delete or overwrite those cells, the combined result may change or show an error. Keep the source data until you have verified the output, or paste the results as values before removing the sources.
Tips
Use a clear heading such as Full Name in D1 so other people can tell what the new column contains. If your worksheet already has a header row, do not overwrite it with the first formula. Keep the same name order throughout the list; a consistent format makes it easier to sort, filter, or export the results later.
For a long list, convert the source range into an Excel table with Insert > Table. When you enter a formula in a table column, Excel can fill it through the table and extend it to new rows. Confirm the resulting references and output rather than assuming the table handled an unusual blank row exactly as you intended.
Consider whether you want a middle initial, suffix, or title included. The three-cell formula only joins the three cells you specify. If you have a suffix such as Jr. in another column, you must include that cell in the formula and decide what separator belongs before it. Do not include unrelated columns such as a preferred name unless that is the format you need.
Keep the formula results in a separate column while you proofread. A combined value is useful for display or exporting, but the separate source fields are easier to edit and reuse in different formats. If a report needs a fixed snapshot, paste values into a separate copy of the output rather than replacing the working formula column immediately.
If you need a comma-separated format, such as Chen, Ava Marie, change the order of the cell references and insert a comma plus a space as the separator. Test the punctuation on one row first. Check how the result should look before filling it down, particularly when names include commas or suffixes already.
Troubleshooting
The cell shows the formula itself. The cell may be formatted as Text, or Excel may be displaying formulas in the worksheet. Select the cell and choose Home > Number Format > General, then edit the formula by pressing F2 and Enter. If formulas are displayed across the sheet, toggle Show Formulas from the Formulas tab. On Windows, Ctrl+` toggles this view; shortcut availability can differ on Mac keyboards. A leading apostrophe before the equals sign can also make Excel treat the entry as text, so remove it.
The result has no spaces or has too many. Check that the formula contains the quoted space between each cell reference. If an empty name cell causes a gap, replace the basic formula with TRIM or TEXTJOIN as described above. TRIM handles ordinary spaces; text copied from a website may contain nonbreaking spaces that TRIM does not remove. If a gap remains, inspect the source cell and remove or replace the unusual whitespace.
The result says #NAME? or another error appears. Check spelling and punctuation in the formula, including the cell references and quotation marks. If you used TEXTJOIN and Excel does not recognize the function, your version may not support it; use the TRIM alternative. If Excel uses a different list separator in your regional settings, its formula-entry requirements may differ from the comma-based examples here. The ampersand formula and TRIM formula shown do not require function argument separators.
Only one row changes when you fill down. Make sure you selected the output cells below the first formula before choosing Home > Fill > Down or pressing the shortcut. If you dragged the fill handle, check that it reached the final row. Click a lower result cell and look at the formula bar to verify that it refers to the matching row of source names.
The names are in the wrong order or a result is blank. Check that the cell references match the actual columns and that the source cells contain the names you expect. A formula can produce an empty result when all referenced cells are blank. Correct the source data or adjust the references, then check the first output before filling the revised formula through the list.
Frequently Asked Questions
Can I merge three name cells without a formula? Yes. You can copy the cells and combine them manually, but this is slow and easy to mistype for a long list. A formula is better when you need consistent results or want the merged name to update when the source cells change.
Will merging the names delete the original cells? No. The formulas in this guide create a combined result in a separate cell; they do not merge or erase the source cells. Excel’s Merge Cells formatting command is different and is generally not appropriate for joining text from several cells.
How do I combine first and last names when the middle-name cell is empty? Use the TRIM version of the formula or TEXTJOIN with the ignore-empty option. Both prevent a blank middle cell from leaving an extra space in the displayed name. TEXTJOIN also skips other empty cells in the range.
Can I join cells that are not next to each other? Yes. Use the same ampersand approach and refer to the specific cells in the order you want. Put a quoted space between each reference. Check the formula carefully if the cells are on different sheets, since sheet names may need to be included in the references.
Why does the combined name not change after I edit a source cell? If the output was pasted as values, it is fixed text and will not update. If it is still a formula, check that Excel calculation is set to Automatic under Formulas > Calculation Options. You can also press F9 to recalculate formulas on Windows; on Mac, the shortcut can vary by keyboard and Excel release.
Related
- Excel Highlight Shortcut: How to Color Cells Quickly
- How to Hide Rows in Excel: Keyboard Shortcuts and Tips
- How to Hide Rows in Excel: Keyboard Shortcuts Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Merge Keyboard Shortcut and Safer AlternativesIn Excel for Microsoft 365 on Windows, select the cells and press Alt, H, M, C in sequence…
- Hide in Excel: Keyboard Shortcuts for Rows, Columns & SheetsTo hide rows in Excel for Microsoft 365 on Windows, select them and press Ctrl+9; to hide columns,…
- Excel Text Box Linked to Cell: Setup, Uses, and FixesYes. In Excel for Microsoft 365 on Windows, select the text box by its outer border, click the…
- Excel Open and Repair Utility: How to Recover a FileExcel’s Open and Repair utility is a built-in feature in the Windows desktop app that can attempt to…
- Body Fat Percentage Tracker in Google Sheets GuideYes. You can make a body fat percentage tracker in Google Sheets by recording the date and repeatable…
- Undo in Excel: Reverse Your Last ActionTo undo the last action in Excel for Microsoft 365 on Windows, press Ctrl+Z. Press it again to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.