How to Concatenate Names in Excel With a Space Easily

Formulas & functions · Updated November 19, 2026

To concatenate first and last names in Excel with a space, put the first name in A2 and the last name in B2, then enter =A2&" "&B2 in C2. For example, if A2 contains Maya and B2 contains Chen, the result is Maya Chen.

The quick formula for two names

The ampersand (&) joins text in Excel. In the formula above, the first reference supplies the first name, the quoted space supplies a separator, and the second reference supplies the last name. The space must be inside quotation marks; without it, Excel puts the names directly together as MayaChen.

To use the formula in your own workbook:

  1. Keep first names in column A and last names in column B, with the first record in row 2.
  2. Select C2, or the first empty cell where you want the combined name.
  3. Enter =A2&" "&B2 and press Enter. With Maya in A2 and Chen in B2, C2 displays Maya Chen.
  4. Copy the formula down for the remaining rows. On Windows, select the formula cell and press Ctrl+D after selecting the cells below it; on Mac, use Command+D. You can also drag the fill handle at the lower-right corner of the cell.

The formula combines the values for display; it does not erase or change the original first- and last-name cells. If you edit either source cell, the combined result updates automatically while Excel is set to calculate formulas automatically.

What concatenation means in Excel

Concatenation is the act of joining text strings in a chosen order. In a name list, the pieces might be a first name, middle name, and surname. Excel does not automatically know that names need a separator, so the formula has to provide punctuation or spacing explicitly. A space is just one text value between the cell references.

In Microsoft 365 for Windows, the ampersand operator is a straightforward option for a small, fixed number of parts. The same formula syntax works in Excel for Mac and Excel for the web. Excel function names and argument separators can vary with language and regional settings, but the examples here use English function names and commas where arguments are needed.

Excel also has the CONCAT and TEXTJOIN functions. CONCAT joins values but does not insert spaces by itself. TEXTJOIN can add a chosen separator between multiple values and can optionally skip empty cells, which makes it useful for names that have optional parts.

Join names when some fields are blank

The basic ampersand formula always inserts the space, even if one of the cells is empty. If A2 is Maya and B2 is blank, =A2&" "&B2 returns Maya followed by a trailing space. If A2 is blank and B2 is Chen, the result begins with a space. Those spaces may be invisible in a cell but can affect later sorting, matching, or exports.

For a simple first-name and last-name pair, wrap the join in TRIM to remove extra spaces at the beginning and end and reduce repeated ordinary spaces between words. With first names in A2 and last names in B2, use =TRIM(A2&" "&B2). If A2 contains Maya and B2 is blank, the result is Maya without a trailing space; if A2 is blank and B2 contains Chen, it returns Chen.

For names with optional middle names or other parts, TEXTJOIN is often easier to extend. With first name in A2, middle name in B2, and surname in C2, enter =TEXTJOIN(" ",TRUE,A2:C2). If A2 is Maya, B2 is blank, and C2 is Chen, the result is Maya Chen. The first argument sets the separator to one space, and TRUE tells Excel to ignore empty cells.

TEXTJOIN is available in Microsoft 365 and newer perpetual Excel versions. In the Microsoft 365 version covered here, it is a practical choice when the number of name components varies. Note that a cell containing a formula that returns an empty string may behave differently from a truly empty cell in some formulas and workflows; check the result if your source data contains formulas or imported blanks.

Include middle names, titles, or suffixes

Names may have more than two parts, and their order depends on the data you want to display. If the columns contain title, first name, middle name, last name, and suffix in A2:E2, respectively, a space-separated join can combine the row while skipping empty cells. For that layout, use =TEXTJOIN(" ",TRUE,A2:E2). If the cells contain Dr., Maya, a blank, Chen, and Jr., the result is Dr. Maya Chen Jr.

Before combining, decide whether the output should preserve every supplied element. A title may be useful in a formal mailing list but unwanted in a casual contact display. A suffix such as Jr. might need a comma in a particular style; TEXTJOIN with a single space will not add that comma automatically. You can either include punctuation in a source cell or use a formula designed for the exact format.

For example, if first name is A2, middle initial is B2, and last name is C2, a space separator gives Maya R. Chen when all three cells contain those values. If the middle initial is optional, TEXTJOIN can omit the blank cell without leaving a gap. Always confirm the intended name order for the people and region represented by the data rather than assuming every record follows the same pattern.

Choose between ampersand, CONCAT, and TEXTJOIN

These methods all combine text, but they suit different layouts. For two required fields, the ampersand formula is short and easy to inspect. CONCAT is another way to join specified cells or text, but it does not supply a separator. TEXTJOIN is especially convenient when there are several fields and some may be empty.

  • Ampersand: Use it when the parts and separators are clear, such as first name, one space, and surname.
  • CONCAT: Use it to join values directly when you are willing to add spaces or punctuation as separate text arguments.
  • TEXTJOIN: Use it to apply the same separator between a range of cells and, when requested, skip empty cells.

For instance, with first name in A2 and last name in B2, =CONCAT(A2," ",B2) returns Maya Chen when the cells contain Maya and Chen. With a range containing several name parts, TEXTJOIN avoids writing each reference and separator separately. There is no universal best formula: choose based on whether blanks are possible and whether the parts are in a continuous range.

Fill the formula down and keep results current

After confirming the first combined name, copy the formula to the other rows. If the formula is in C2 and the records run through row 20, select C2:C20 and use Ctrl+D on Windows or Command+D on Mac to fill the top cell’s formula down. Alternatively, drag the fill handle or copy C2 and paste into the destination cells. Excel adjusts relative references, so the next row normally becomes a formula using A3 and B3.

Use a header such as Full Name in C1, and leave the formula results below it. If you add new rows later, copy the formula into them as well. Turning the data range into an Excel table with Insert > Table can help keep related data organized; formulas entered in a table column may be filled down as a calculated column. Review the new rows after adding data, especially if the source columns include blanks or inconsistent entries.

Formulas are useful when the source names may change. If you need a fixed list for an upload or report, you can copy the results and use Home > Paste > Paste Values to replace the formulas with their current displayed values. Keep a copy of the original columns first if you may need to revise the formatting or fix source data later.

Fix extra spaces and other common problems

A formula can be syntactically correct and still produce an awkward-looking result because the source cells contain extra whitespace. TRIM removes ordinary leading and trailing spaces and reduces repeated ordinary spaces within text. For example, if A2 or B2 contains accidental extra spaces, the TRIM formula can clean the joined result. It does not remove every kind of whitespace, such as some nonbreaking spaces that can arrive from web pages or copied documents.

If names still appear to have odd gaps, inspect the source cells and consider replacing unusual whitespace before concatenating. You can also test a copied value in a separate cell with TRIM. Avoid applying broad cleanup blindly: repeated spaces can be meaningful in some text, and names may contain punctuation, particles, or formatting conventions that should be preserved.

  • No space appears: Include a quoted space, such as " ", between the cell references.
  • There is a leading or trailing gap: Use TRIM around a simple join, or use TEXTJOIN with TRUE for optional blank fields.
  • The formula displays instead of calculating: Check that the cell is not formatted as Text, and that the entry begins with an equals sign. Change the format to General if needed, then re-enter the formula.
  • You see #NAME? or another error: Check the function spelling and the regional argument separator. The ampersand version avoids function names and function arguments.

Do not confuse concatenating names with sorting them. A formula can create a display name in one column, but it does not rearrange the records or change the original values. If you need surname-first output, swap the order of the source references and choose the desired punctuation and spacing.

Frequently Asked Questions

How do I combine first and last names in Excel with a space?
With first name in A2 and last name in B2, enter =A2&" "&B2 in the output cell. The formula inserts one space between the two cell values.

How do I combine names without extra spaces when a cell is blank?
For first, middle, and last names in A2:C2, use =TEXTJOIN(" ",TRUE,A2:C2). TEXTJOIN inserts a space between included values and skips empty cells when its second argument is TRUE.

Can I concatenate names with a comma?
Yes. With first name in A2 and last name in B2, the formula =B2&", "&A2 displays the surname first, as Chen, Maya. Change the order or separator to match the format you need.

Will the combined name update if I change a source cell?
Yes. A formula result recalculates when a referenced value changes, provided Excel calculation is set to Automatic. Pasted values do not update because they are no longer formulas.

Can I join names from more than two cells?
Yes. Use ampersands to connect a few specific cells, or TEXTJOIN for a range of name parts with a repeated separator. For optional parts, TEXTJOIN with TRUE can avoid separators for empty cells.

Does concatenating names remove the original columns?
No. The formula creates a result in another cell and leaves the source cells unchanged. You can keep both versions or copy the results and paste values if you need a standalone list.

Related

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.