To concatenate names in Excel, join the cells with the ampersand operator and add a space between them: if A2 contains Maria and B2 contains Garcia, enter =A2&" "&B2 in another cell to return Maria Garcia. You can also use CONCAT or, when you need to skip blank cells, TEXTJOIN.
What concatenating names means
Concatenating means combining text from two or more cells into one value. For a name list, that usually means joining first and last names, but the same idea works for middle names, initials, titles, and other text. The source cells remain unchanged; the combined name appears in the cell where you enter the formula.
The separator is important. Excel does not automatically insert a space between joined values. If A2 contains Maria and B2 contains Garcia, joining just the cell references produces MariaGarcia. Add a space inside quotation marks in the formula to get Maria Garcia. You can use a comma, hyphen, or other text as the separator when that fits the format you need.
Join first and last names with the ampersand
The ampersand (&) is a straightforward choice for joining two or a few cells. It works in current Excel and older versions, and it makes the position of each piece of text easy to see. In the example below, A2 holds the first name Maria and B2 holds the last name Garcia.
With the first name in A2 and the last name in B2, enter this formula in C2; with Maria and Garcia as the cell values, it returns Maria Garcia:
=A2&" "&B2
To use it for a list, enter the formula beside the first row of names. Select the formula cell and drag its fill handle—the small square at the lower-right corner—down the column. Excel adjusts the references for each row, so the next formula uses A3 and B3, then A4 and B4, and so on. Double-clicking the fill handle can also fill down alongside a continuous neighboring data range.
Use CONCAT to combine name cells
CONCAT is a function-based alternative to the ampersand. It joins text or cell references in the order supplied, but it does not add spaces or other separators for you. Include the separator as a text argument. CONCAT is available in Microsoft 365 and newer Excel versions; if you work with older workbooks, the ampersand is a broadly compatible option.
With Maria in A2 and Garcia in B2, enter this formula in C2; it returns Maria Garcia:
=CONCAT(A2," ",B2)
For two cells, CONCAT and the ampersand usually give the same result. CONCAT can be convenient when a formula includes several pieces, but the key rule is unchanged: type the desired separator explicitly. CONCAT does not offer an option to ignore empty cells, so a separator may still appear when one of the name cells is blank.
Use TEXTJOIN when some names are blank
TEXTJOIN is useful when names occupy several columns and some components may be empty. It takes a delimiter, an instruction about whether to ignore empty values, and the text or range to combine. Set the second argument to TRUE to skip empty cells and avoid extra separators caused by blank cells.
With first, middle, and last names in A2, B2, and C2 respectively, enter this formula in D2. If A2 contains Maria, B2 is empty, and C2 contains Garcia, it returns Maria Garcia:
=TEXTJOIN(" ",TRUE,A2:C2)
TEXTJOIN is available in Microsoft 365 and supported newer Excel versions, including Excel 2019 and later. The option to ignore empty cells does not repair missing data: if the first or last name is absent, the formula simply joins the values that are present. If a cell contains a space rather than being empty, Excel may treat it as text, so the space can still affect the result. You can clean such input if needed.
Choose a separator and display format
Decide how the combined name should look before filling the formula down. A space is common for a standard first-name-last-name display, while a comma can put the surname first. Use the format consistently if the result will be sorted, printed, imported into another system, or matched against another list.
- First name and last name: A space gives a readable full name, as in Maria Garcia.
- Last name first: A comma and space can produce Garcia, Maria.
- Initials or labels: Add punctuation or fixed text as literal text in quotation marks, checking that the intended spaces are included.
With the first name Maria in A2 and last name Garcia in B2, enter this formula in C2; it returns Garcia, Maria:
=B2&", "&A2
Concatenation does not know which part of a person’s name is a surname. It follows the cells and order you specify. This matters for names with multiple given names, compound surnames, particles, suffixes, or naming conventions where family names do not appear last. Keep the original fields intact and choose the displayed order for your actual data rather than assuming every name follows one pattern.
Clean extra spaces and inconsistent entries
Extra spaces in source cells can make the result look uneven. For example, if A2 has a trailing space and B2 has a leading space, joining them with another space may leave multiple spaces in the middle. TRIM removes leading and trailing spaces and reduces repeated ordinary spaces between words. It can help when the source data contains accidental spacing, though it does not standardize capitalization or correct misspelled names.
With A2 containing “ Maria ” and B2 containing “ Garcia”, enter this formula in C2; it returns Maria Garcia with the extra outside spaces removed:
=TRIM(A2&" "&B2)
TRIM is not a universal cleanup tool. It targets ordinary spaces, not every invisible character that can arrive through a web export or copied data. If a result still looks misaligned, inspect the source cells and consider whether they contain nonbreaking spaces or other characters. Avoid changing names automatically just to make entries look uniform; preserve accents, hyphens, apostrophes, and capitalization unless your data requirements call for a specific change.
Fill formulas, check results, and keep a static copy
After confirming the formula on one row, fill it through the rest of the list and check several results, including rows with blank middle names or unusual punctuation. If you turn the source range into an Excel Table using Insert > Table, a formula entered in a table column can fill down that calculated column automatically. Tables are especially useful when new rows will be added later.
A formula result updates when its source cells change. If you need to keep the combined names as fixed text—for example, before sending a file to a system that should not receive formulas—copy the result column, then use Home > Paste > Paste Values to replace the formulas with their displayed values. Keep a copy of the original workbook if you may need to edit or regenerate the names later.
In Excel for the web, the same formulas work, and the formula can be filled down using the fill handle. Ribbon labels and paste options can vary slightly by platform and layout. On Mac, the formulas are the same; the main differences are interface details and keyboard shortcuts, not the way concatenation works.
Common problems and how to fix them
- No space between names: Add a quoted space between the references. Excel will not insert one automatically.
- A space appears even when a name is blank: A simple ampersand formula or CONCAT with a fixed separator still includes that separator. Use TEXTJOIN with TRUE to ignore empty cells, or make a formula that checks for blanks if you need a specific two-field layout.
- The formula shows as text: Check that the cell is not formatted as Text, and that the formula begins with an equals sign. Change the format to General and re-enter the formula if necessary.
- Excel reports a formula error: Check that quotation marks and parentheses are balanced. Excel installations using a regional list separator may require semicolons instead of commas between function arguments; the examples here use commas.
- Names are joined in the wrong order: Rearrange the cell references in the formula. Excel does not infer whether a field contains a first or family name.
- Changing a source name changes the result: That is normal for a formula. Paste the results as values if you need a fixed snapshot.
Frequently Asked Questions
What is the simplest formula to join first and last names in Excel?
Use the ampersand with a quoted space between the cells. If the first name is in A2 and the last name is in B2, =A2&" "&B2 returns a full name with one space between the parts.
Is CONCAT better than the ampersand?
Neither is always better. Both can join name cells when you supply the separator. The ampersand is concise for a couple of cells and works in older Excel versions; CONCAT can be readable for several arguments. Use TEXTJOIN if skipping empty components is important.
How do I join first, middle, and last names when the middle name is optional?
Put the components in separate cells and use TEXTJOIN with a space delimiter and TRUE for its ignore-empty argument. For example, with the fields in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins the populated cells without inserting a separator for an empty middle-name cell.
Can I combine names without changing the original columns?
Yes. Enter the formula in a separate output column. Concatenation reads the source cells but does not overwrite them. You can hide the source columns or keep them visible, depending on how the workbook will be used.
Can Excel split the combined name back into first and last names?
Sometimes, but splitting is only reliable when the original names follow a consistent pattern and the separator is unambiguous. A full name may contain multiple spaces or compound surnames, so keeping first, middle, and last names in separate source columns is safer than relying on a split formula to reconstruct them.
Related
- Calculate the Middle Date Between Two Dates in Excel
- Calculate Average Time Between Dates in Excel with AVERAGE
- Budget vs Actual Excel Template: Build and Use One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel FLOOR Function: How to Round Decimal Values DownTo round a decimal down in Excel, use FLOOR.MATH with the increment you want. With a value of…
- COUNTA Function in Excel: Count Nonblank Cells CorrectlyTo count nonblank cells in Excel, use COUNTA. With five entries and two truly empty cells in A2:A8,…
- Excel CLEAN Function: Remove Nonprinting CharactersTo remove nonprinting characters from text in Excel, enter =CLEAN(A2) in a helper cell when the source text…
- Excel XLOOKUP Examples for Common Spreadsheet TasksMicrosoft Excel’s XLOOKUP finds a value in one range and returns the corresponding value from another. For example,…
- Excel Text Filter for More Than Two Criteria: 3 WaysExcel’s standard Text Filters menu lets you combine only two conditions in its Custom Filter dialog. To filter…
- Excel Number Format to Round Values to Millions EasilyTo display Excel values in millions without changing the stored numbers, apply the custom number format #,##0.0,,"M". The…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.