Concatenate Excel Formula With Comma: Examples

Formulas & functions · Updated November 18, 2026

To concatenate two cells with a comma and a space between them, use =A2&", "&B2. For example, if A2 contains Maya and B2 contains Chen, the result is Maya, Chen; the comma and space are text enclosed in quotation marks.

What the comma does in a concatenation formula

Concatenating means combining text from separate cells into one text string. A comma is not inserted automatically: you add it as a text value between the cell references. In the basic example, the ampersands join three pieces in order: the value in A2, the literal comma-and-space text, and the value in B2. The space after the comma is included because it is inside the quotation marks.

This distinction matters because Excel formulas also use commas to separate function arguments. In the basic ampersand formula, the comma is part of quoted text, so Excel displays it in the result. In a function formula, a comma outside quotation marks may instead separate one argument from another. The position and quotation marks tell Excel how to interpret it.

If you want no space after the comma, put only a comma inside the quotes. If you want a space before it, include that space before the comma instead. Exact punctuation is controlled by the text you place between the cell references, not by the values in those cells.

Use the ampersand operator for a simple result

The ampersand (&) is the most direct way to combine a small number of cells with punctuation. With names in A2 and B2, enter the formula below in C2. If A2 is Maya and B2 is Chen, C2 displays Maya, Chen.

Assume A2 contains Maya and B2 contains Chen:

=A2&", "&B2

You can enter the formula directly in a cell or in the formula bar. Press Enter to calculate it. To apply the same pattern to more rows, drag the fill handle from the cell containing the formula down the column. Excel adjusts the relative references, so the next row will refer to A3 and B3. If you copy the formula elsewhere, check that the adjusted references still point to the intended source cells.

The ampersand method is useful when the order and punctuation are fixed and there are only a few pieces to combine. It also makes the output easy to customize: add another ampersand and a quoted separator wherever you want punctuation or a label. Remember that the result is text. It will not behave like two separate source cells, and editing either source value updates the result automatically.

Join three or more cells with commas

For a fixed set of three cells, repeat the same pattern between each value. Assume A2 contains Maya, B2 contains Chen, and C2 contains Seattle. The result is Maya, Chen, Seattle. Notice that the formula adds a comma and a space between every pair of cells, including before the final value.

With Maya in A2, Chen in B2, and Seattle in C2:

=A2&", "&B2&", "&C2

This approach works for any small, known number of fields, such as first name, last name, and city. Its drawback is that each additional cell makes the formula longer, and each separator must be added manually. If you later insert a new field or need to combine a long range, a function designed to join text can be easier to maintain.

Make sure the source cells are in the intended order. Excel follows the order in the formula; it does not sort the values or infer a preferred arrangement. If the output will be used as a label or a display name, check whether the comma belongs between every item or only between particular fields.

Use CONCAT or CONCATENATE

CONCAT combines text from cells or text values, and it can make a formula’s joining action clear at a glance. It does not add commas automatically, so include the separator as an argument. In current Microsoft 365 Excel for Windows, CONCAT is generally the more suitable function for new formulas; it is available in Excel 2016 and later.

With Maya in A2 and Chen in B2:

=CONCAT(A2,", ",B2)

The result is Maya, Chen. CONCATENATE can produce the same result and remains available for compatibility with older workbooks, but Microsoft identifies it as a legacy function. For a new formula, the ampersand or CONCAT is usually a clearer choice. Neither CONCAT nor CONCATENATE automatically skips empty cells or inserts separators for you; the formula must specify what text to join.

Function arguments are separated by commas in the formulas shown here. Some Excel regional settings use semicolons as argument separators instead. If Excel reports a formula error in such a setup, the argument separators may need to match the local setting. Do not change a comma that is inside quotation marks when it is intended to appear in the output.

Use TEXTJOIN for a range or optional fields

TEXTJOIN is especially useful when you need the same delimiter between many cells. Its arguments let you specify the delimiter, whether to ignore empty cells, and the text or range to combine. It is available in Microsoft 365 and Excel 2019 or later. The delimiter is added between included values, rather than before the first or after the last value.

Assume A2 contains Red, A3 is blank, A4 contains Blue, and A5 contains Green:

=TEXTJOIN(", ",TRUE,A2:A5)

The result is Red, Blue, Green. The TRUE argument tells Excel to ignore empty cells, so the blank A3 does not create an extra comma. If you set that argument to FALSE, empty cells are not ignored; this can leave adjacent delimiters where blank entries occur. Choose the setting based on whether empty fields should disappear or preserve their positions.

TEXTJOIN can also combine a row of optional details. Assume A2 contains Maya, B2 contains Chen, and C2 is blank:

=TEXTJOIN(", ",TRUE,A2:C2)

The result is Maya, Chen, with no trailing comma. This is often simpler than building a chain of ampersands when fields may be missing. However, TEXTJOIN does not remove spaces that are already inside a nonblank cell. If a source value contains unwanted leading or trailing spaces, clean that value or use a trimming approach before joining.

Preserve date and number formatting

When Excel combines a cell containing a number or date with text, it may display the underlying value rather than the format you see in the source cell. A date can appear as a serial number, and a number formatted with currency or decimal places may lose that display formatting. The cell’s number format does not automatically carry over into the joined text.

Use TEXT to specify how the value should appear in the result. Assume A2 contains Invoice and B2 is an Excel date representing April 7, 2026:

=A2&", "&TEXT(B2,"mmm d, yyyy")

The result is Invoice, Apr 7, 2026. The format pattern inside TEXT controls the displayed date; for example, a different pattern can show a numeric month or a four-digit day. The date must be stored as a real Excel date for the pattern to format it as expected. If B2 contains date-like text instead, first check how that value is stored.

The same principle applies to numbers. If a value must display with a specific number of decimal places, use TEXT with an appropriate number format rather than assuming the original cell formatting will follow it into the concatenated result. Once formatted and joined, the output is text, so it is intended for display rather than further numeric calculations.

Handle extra spaces and missing values

A formula can produce an awkward result if one source cell is blank. The simple ampersand version will still include the comma and space, which can leave punctuation at the end. For two fields where the second value is optional, an IF formula can return an empty string when that cell is blank. Assume A2 contains Maya and B2 is blank; the result is an empty cell display rather than Maya followed by a comma.

With a name in A2 and an optional second value in B2:

=IF(B2="","",A2&", "&B2)

If B2 contains Chen, the result is Maya, Chen. This particular formula returns nothing when B2 is blank, so it is appropriate only when the whole output should be omitted in that case. If you want Maya to remain visible when B2 is blank, use TEXTJOIN with the range and its ignore-empty option instead.

Unwanted spaces can also come from imported or manually entered data. TRIM removes leading and trailing ordinary spaces and reduces repeated internal spaces to single spaces. Assume A2 contains the text Maya with an extra trailing space and B2 contains Chen with an extra leading space:

=TRIM(A2)&", "&TRIM(B2)

The result is Maya, Chen with clean spacing. TRIM does not remove every possible invisible character, such as some nonbreaking spaces copied from websites. If the visible result still looks misaligned after trimming, inspect the source values for those characters rather than adding more punctuation to the formula.

Common errors and practical checks

Most problems come from placing quotation marks incorrectly, omitting a separator, or confusing the comma in the output with a function argument separator. Check the formula from left to right: each cell reference should be joined to the next piece, the displayed comma should be inside quotation marks, and every opening quotation mark should have a matching closing one. Excel may show a formula warning if a quote or parenthesis is missing.

  • No space after the comma: confirm that the quoted separator includes a space after the comma if that is the intended style.
  • Unexpected blank space: inspect the source cells for extra spaces, then consider TRIM or TEXTJOIN’s ignore-empty option.
  • A date or number looks wrong: format it with TEXT before combining it with other text.
  • The formula is rejected: check for mismatched quotation marks and whether your regional settings expect a different function-argument separator.
  • The result does not update: check that calculation is set to Automatic under Formulas > Calculation Options, and verify that the formula refers to the cells you changed.

A related misconception is that concatenation creates a list that Excel can later split back into the original fields automatically. The formula creates one text value; it does not preserve a structured relationship between the joined pieces. If the result is intended for later data processing, keeping the original values in separate columns is usually safer. A comma inside a value can also make a comma-separated export ambiguous unless the receiving format handles quoted fields correctly.

Which method should you choose?

For two cells and one separator, the ampersand is concise and easy to understand. Choose CONCAT when you prefer a function-based approach or are combining several pieces of text. Use TEXTJOIN when joining a range or when empty cells should be skipped consistently. CONCATENATE remains useful when maintaining an older workbook, but it is not necessary for a new formula.

Think about the data as well as the formula. If the values are optional, decide whether blanks should disappear or occupy a position. If they contain dates or formatted numbers, decide how those should appear as text. If users will edit the workbook later, a formula that clearly expresses the separator and blank-handling behavior will be easier to review and maintain.

Finally, remember that concatenation changes presentation, not the underlying source cells. You can copy the result and use Paste Special > Values if you need a static text version, but doing so removes the live link to the original cells. Keep the formula when the combined value should update as the source data changes.

Frequently Asked Questions

How do I add a comma and a space between two cells in Excel?
Join the cell references with an ampersand and put a comma followed by a space in quotation marks between them. The basic example above produces a result such as Maya, Chen.

How do I concatenate cells with commas but no spaces?
Use a comma by itself as the quoted separator. The text between the quotation marks is exactly what Excel inserts, so leave out the space if you do not want one.

How do I put commas between many cells and ignore blanks?
Use TEXTJOIN with a comma-and-space delimiter and set its ignore-empty argument to TRUE. Supply the range of cells you want to combine; blank cells will not add extra separators.

Why does my concatenated date show as a number?
Excel is using the date’s underlying stored value in the text result. Wrap the date reference in TEXT and choose a date format pattern to show a readable date.

Can I use CONCATENATE instead of CONCAT?
Yes. CONCATENATE remains available for compatibility, but CONCAT or the ampersand operator is generally more suitable when writing a new formula. Both require you to provide the comma separator yourself.

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.