Concatenate in Excel with the Ampersand (&) Operator

Formulas & functions · Updated November 20, 2026

To concatenate text in Excel, enter an ampersand between the cell references you want to join. With a first name in A2 and a last name in B2, type =A2&" "&B2 in another cell and press Enter; if A2 is Maya and B2 is Chen, the result is Maya Chen. The ampersand joins values, while the quoted space supplies the separator. You can join two or more cells, add labels or punctuation, and copy the formula down a column.

What You’ll Need

  • A workbook in Microsoft Excel for Microsoft 365 on Windows. The ampersand operator also works in Excel for Mac and Excel for the web.
  • The cell references or text you want to combine, plus a blank cell for the result.
  • A clear idea of whether you want spaces, commas, hyphens, or another separator between the joined values. The ampersand does not add one automatically.

Step-by-Step

  1. Identify the source cells. For a simple example, put a first name in A2 and a last name in B2. Choose an empty cell, such as C2, for the combined name. Check that the source cells contain the values you want; the formula combines what is in the cells rather than changing or moving those values.

  2. Start the formula in the result cell. Click C2 and type an equals sign, then select or type the first reference. With the names in A2 and B2 and the result in C2, enter =A2&" "&B2. The ampersand between A2 and the quoted space, and another between the space and B2, joins all three pieces. Press Enter to calculate it.

  3. Check the separator and result. If A2 contains Maya and B2 contains Chen, C2 should display Maya Chen. The characters inside quotation marks are literal text, so " " contributes one space. If you omit that piece and enter =A2&B2, the result is MayaChen. Add exactly the separator you want between the references; a space before or after the formula does not create a separator in the result.

  4. Join more cells or include fixed text. You can continue the pattern for a middle initial or other value. With a first name in A2, middle initial in B2, and last name in C2, enter =A2&" "&B2&" "&C2 in D2. If the cells contain Maya, R, and Chen, the result is Maya R Chen. To add a fixed label, put it in quotation marks. With an order number in A2 and the result in B2, ="Order "&A2 displays Order followed by the value in A2.

  5. Use a separator that suits the data. Text inside quotation marks can include punctuation as well as spaces. With a city in A2 and a state code in B2, enter =A2&", "&B2 in C2 to produce a result such as Portland, OR. With a product code in A2 and a size in B2, =A2&" - "&B2 inserts a space, hyphen, and space. Keep the separator inside quotes so Excel treats it as text.

  6. Copy the formula to other rows. If the source data continues down columns A and B, select C2 and use the fill handle: point to the small square at the lower-right corner of the cell and drag it down the rows you need. You can also copy C2, select the destination range, and paste. Excel adjusts relative references as the formula moves, so the next row refers to A3 and B3, then A4 and B4, and so on. On Windows, Ctrl+C and Ctrl+V copy and paste; on Mac, use Command+C and Command+V. The fill handle works in both.

  7. Review the combined column. Check several rows, especially the first and last, for missing spaces, unexpected blanks, or values that look different from the source formatting. If the result will be shared as a fixed list rather than kept linked to the source cells, you can copy the result range and use Home > Paste > Paste Values. This replaces the formulas with their current displayed results, so keep a copy of the formula-based data if you may need to update it later.

Common Mistakes

Leaving out the separator: A formula that joins A2 directly to B2 puts the values together without a space or punctuation. Insert a quoted separator between the references, such as " " for a space or ", " for a comma and space. If the output has two spaces, check whether a source cell already has a leading or trailing space.

Forgetting quotation marks around literal text: A fixed word or punctuation mark must be enclosed in straight double quotation marks in the formula. For example, with a status in A2, the formula =A2&" complete" adds the word complete after the cell value. Without quotes, Excel may interpret the text as a name and return an error such as #NAME?. Do not put quotation marks around cell references; Excel needs to read them as references.

Typing the formula without an equals sign: A formula starts with =. Without it, Excel generally treats the entry as ordinary text rather than calculating it. Also use the ampersand character &, not the word “and” or a plus sign, to join text values.

Expecting the source formatting to carry over: Concatenation joins a cell’s value, not its font, color, number format, or date appearance. A number formatted with a currency symbol or a date displayed as a long date may appear differently after joining. Format the value inside the formula when its presentation matters.

Tips

Keep separators consistent. Decide whether names should be separated by a space, addresses by commas, or codes by hyphens, then use the same pattern for every row. This makes the results easier to scan and prevents later cleanup. When joining text that already contains punctuation, inspect the source values first so the formula does not create doubled commas or extra spaces.

Preserve a date’s readable display. If B2 contains a date and A2 contains an event name, a plain join may show the date’s underlying serial number instead of its formatted appearance. With the event in A2, the date in B2, and the result in C2, use =A2&" — "&TEXT(B2,"mmm d, yyyy"). If A2 is Launch and B2 is January 15, 2025, the result is Launch — Jan 15, 2025. TEXT applies the specified display format to the date before it is joined.

Decide how blank cells should behave. A blank cell contributes no visible value, but separators in the formula still appear. For example, if B2 is blank, a formula that joins A2, a space, and B2 can leave a trailing space. With a name in A2, an optional second name in B2, and the output in C2, use =IF(B2="","",A2&" "&B2) if you want C2 blank whenever B2 is blank. If you would rather keep A2 visible when B2 is empty, use =IF(B2="",A2,A2&" "&B2). These examples assume Excel’s standard comma argument separator.

Use references for changing values. Referencing cells means edits to the source values flow through to the combined result. If you type all the names or labels directly into a formula, those pieces will not update when the worksheet data changes. For reusable lists, keep the source parts in separate columns and build the result from references.

Make the result independent only when needed. A formula result updates when its source cells change. If you need a snapshot, copy the finished cells and paste values into a separate range. Remember that pasted values will no longer update automatically, and replacing formulas is difficult to reverse after you close the workbook.

Troubleshooting

The formula appears as text instead of producing a result. Confirm the entry begins with =. If it does, the cell may be formatted as Text, or the entry may have a leading apostrophe. Change the cell format to General using Home > Number Format > General, then re-enter the formula: select the cell, press F2, and press Enter. On many Mac keyboards, you may need to hold Fn while pressing F2, depending on the keyboard settings.

You see #NAME? or another error. Check that every literal word or separator is enclosed in straight double quotation marks, and that each cell reference is valid. A misspelled function name can cause #NAME? too; the date-format example uses Excel’s TEXT function. If you copied a formula from a document, replace any curly quotation marks with straight quotes. Also make sure each opening quote has a matching closing quote.

The result has an unexpected number or date. Concatenation does not automatically preserve the source cell’s number format. For a date, wrap the date reference in TEXT and specify a format such as "mmm d, yyyy", as shown in the Tips section. For numeric values, use TEXT with an appropriate number format when you need fixed decimal places or separators. Check that the format string matches the output you want before filling the formula down.

Only the first row works, or every row repeats the same values. Inspect the references in a copied formula. Normally, relative references should change as you fill down: a formula for row 2 should use row 2’s source cells, and the next row should use row 3. If you used dollar signs, such as $A$2, those references are locked and will stay on row 2 when copied. Remove the dollar signs if each output row should use that row’s values.

Extra spaces or punctuation appear. Look at the source cells as well as the formula. A source value may contain spaces you cannot easily see, or a separator may appear at an edge when one of the cells is blank. Edit the source value or adjust the formula so the separator is included only when appropriate. If the values have been imported from elsewhere, check a few source cells directly before filling the formula across the whole table.

Frequently Asked Questions

Is the ampersand the same as CONCATENATE in Excel?
Both can join text, but & is an operator you place between values in a formula. CONCATENATE is an older function, while CONCAT is available in current Excel versions. For a short join, the ampersand is direct and easy to read; you do not need a special function to use it.

Can I concatenate text from more than two cells?
Yes. Add another ampersand and cell reference for each piece, placing quoted separators between them wherever you want spaces or punctuation. For a long list with a repeated delimiter, a function such as TEXTJOIN may be more convenient, but a chain of ampersands works well for a small number of cells.

Can I join cells without adding a space?
Yes. Put the ampersand directly between the cell references and do not include a quoted space. This is useful for combining codes or words that should touch. If the values are names or separate words, add a quoted space to avoid running them together.

Will my formula update if I change a source cell?
Yes. A formula that references a cell recalculates when that cell changes, provided Excel calculation is set to Automatic. If you pasted the result as a value, it is no longer connected to the source and will not update.

Does ampersand concatenation work in Excel for Mac and the web?
Yes. The & operator works in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web. The basic formula is the same. Ribbon labels and keyboard shortcuts can differ by platform, but you can enter the formula directly in a cell in each version.

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.