Excel CONCATENATE With Commas: Formulas and Examples

Formulas & functions · Updated November 18, 2026

To concatenate two Excel cells with a comma and a space between them, use =A2&", "&B2. For a range with several cells, =TEXTJOIN(", ",TRUE,A2:C2) inserts the comma separator and skips empty cells; both formulas return one combined text value.

What concatenating with commas means

Concatenation means joining text or cell values into a single text string. The comma is a character you add as a separator; it does not appear automatically just because you are combining cells. In a formula, put the comma inside straight double quotation marks. Add a space after it if you want the familiar comma-space style, as in “Mia, Chen.” Without the space, the result is “Mia,Chen.”

There are two different uses of commas to keep straight. A comma inside quotation marks is literal text that will appear in the result. A comma outside quotation marks separates function arguments in standard English-language Excel formulas. For example, the first comma in a TEXTJOIN formula can be part of the quoted delimiter, while later commas separate the delimiter, the empty-cell setting, and the cells or range to join. In some regional settings, Excel uses semicolons between function arguments instead. If Excel rejects a formula copied from another setting, check the list separator used by your installation; do not remove the quotation marks around the comma you want displayed.

Join two cells with a comma

The ampersand operator is often the clearest choice for two or a few cells. It joins each piece in the order written, so you can place text, cell references, and additional text around the separator. For example, with a first name in A2 and a last name in B2, the comma-space text belongs between the two references.

With A2 containing Mia and B2 containing Chen, use =A2&", "&B2; the result is Mia, Chen.

To add a comma after a value rather than between two values, put it at the end of the formula’s text portion. To use a different separator, change the quoted text: a semicolon, slash, line break, or the word “and” can be used instead. A separator is not the same as a space already present in a cell, so check the source values if the result looks oddly spaced.

Join several cells with TEXTJOIN

For a list of values, TEXTJOIN is usually more convenient than typing the separator between every cell reference. Its arguments specify the delimiter, whether to ignore empty cells, and the text or range to combine. TEXTJOIN is available in Microsoft 365 and Excel 2019, 2021, and 2024. It can combine a row or a column, and the result is still one cell containing text.

With A2 containing Mia, B2 blank, and C2 containing Chen, use =TEXTJOIN(", ",TRUE,A2:C2); the result is Mia, Chen. The TRUE setting tells Excel to ignore empty cells. If the range contains A2 = Mia, B2 = Chen, and C2 = Rivera, the same formula returns Mia, Chen, Rivera.

If you set the ignore-empty argument to FALSE, Excel preserves the position of empty cells by placing delimiters for them. That may be useful when empty positions have meaning, but it can produce consecutive commas or a delimiter at the beginning or end of the result. Use TRUE for ordinary lists where blank cells should simply be left out. A range such as A2:A20 can be used instead of A2:C2; keep in mind that the output can become long, and a cell’s text result has Excel’s 32,767-character limit.

TEXTJOIN does not clean up extra spaces or punctuation already inside the cells. For instance, a cell containing “ Chen ” contributes those spaces to the result. Clean the source data or use suitable trimming and cleanup in a separate step if neat output matters.

CONCAT, CONCATENATE, and the ampersand compared

Excel offers several ways to combine values. The ampersand is compact and works well for a small, fixed number of pieces. CONCAT can combine text or ranges, but it does not let you specify a delimiter or skip blanks automatically. TEXTJOIN is designed for joining a list with a chosen delimiter. The older CONCATENATE function remains available for compatibility with older workbooks, although Microsoft recommends CONCAT as its replacement.

With A2 containing Mia and B2 containing Chen, =CONCAT(A2&", ",B2) returns Mia, Chen. CONCAT is available in Microsoft 365 and Excel 2019, 2021, and 2024. With the same two cells, =CONCATENATE(A2,", ",B2) returns the same result and can help when maintaining a workbook that already uses that older function.

For CONCATENATE, each piece—including the comma-space separator—must be a separate argument. With three cells, the formula gets longer because the separator must be inserted between each pair. TEXTJOIN avoids that repetition for ranges. For simple two-cell formulas, however, the ampersand is easy to read and is supported across a wide range of Excel versions. Choose based on the number of cells, whether blanks matter, and whether the workbook must work in older versions.

Preserve dates, currency, and number formatting

When Excel joins a number or date directly, it may use the underlying value rather than the display format you see in the worksheet. A date displayed as “January 5, 2026” may become a serial number in a concatenated string. Currency formatting, leading zeros, and percentages can have the same issue. If the appearance matters, convert that value to formatted text with TEXT before joining it.

With A2 holding a real Excel date for January 5, 2026, and B2 containing Seattle, use =TEXT(A2,"mmmm d, yyyy")&", "&B2; the result is January 5, 2026, Seattle. The TEXT format pattern controls the date’s appearance. A value stored as text rather than as a real Excel date may not behave as expected, so verify the source cell if the result is unexpected.

With A2 containing the item name Mug and B2 containing the number 12.5, use =A2&", "&TEXT(B2,"$#,##0.00"); the result is Mug, $12.50 in a setup that uses the dollar sign and decimal point shown. The format code in TEXT is not a change to the underlying value; the formula creates a text representation. Currency symbols and decimal conventions can vary by locale, so adapt the format code to the intended audience. Once converted into a string, the result is not a numeric amount for ordinary arithmetic without converting it back.

Handle empty cells and separators carefully

Decide what a blank cell should mean before choosing a formula. TEXTJOIN with TRUE is helpful when blank cells should disappear from a list. The ampersand method does not skip a blank automatically: if B2 is empty in a formula joining A2, B2, and C2 with separators written manually, the output can contain two adjacent separators. For a short, fixed layout, that may be acceptable; for a list with possible gaps, TEXTJOIN is generally simpler.

Also inspect the cell contents for punctuation. If a value already ends with a comma, adding a comma delimiter can create doubled punctuation. If the values are addresses or imported text, they may already contain comma-space characters. A formula joins what is there; it does not know whether a comma is meaningful within a value or is intended to divide list items.

Finally, commas can be ambiguous when the finished string is later saved as a CSV file. CSV uses commas to separate fields, and values containing commas generally need appropriate quoting in the file. A comma-separated string in one Excel cell is not the same thing as several separate CSV columns. If the goal is to create a data file for another system, check that system’s import requirements instead of assuming that joining cells creates a correctly structured CSV export.

Enter the formula and fill it down

In Excel for Microsoft 365 on Windows, select the destination cell, type the formula in the formula bar or directly into the cell, and press Enter. If each row has its own values, use relative references such as A2 and B2 so they adjust as the formula is copied. Select the formula cell and drag its fill handle down, or double-click the fill handle to copy it alongside adjacent data. Review the last few rows to confirm the references stayed aligned.

On Mac, formulas work the same way, and the fill handle is also available. Keyboard shortcuts differ: Windows uses Ctrl+C and Ctrl+V to copy and paste, while Mac uses Command+C and Command+V. Excel for the web also supports these formulas; the interface may look different from the Windows desktop ribbon, but the formula syntax and cell-reference behavior are the same when the workbook’s regional list separator matches.

If you want to keep the combined text but not the formulas, copy the result cells and use Paste Special > Values on the Windows desktop version of Excel. This replaces formulas with their current displayed results, so do it only when you no longer need the combined values to update as the source cells change. Keep a copy of the formulas or workbook first if the original data may need revision.

Common formula problems

  • Missing comma: Check that the comma is inside quotation marks. A comma used only to separate function arguments will not be displayed as part of the result.
  • Wrong spacing: Use a quoted comma followed by a space if the desired result is “Mia, Chen.” A comma alone produces “Mia,Chen.”
  • Formula error after pasting: Your regional settings may require semicolons between function arguments. Keep the quoted delimiter itself as the text you want to appear.
  • Unexpected date or number: Use TEXT with a suitable format pattern to control how dates, currency, percentages, or leading zeros appear in the joined text.
  • Extra or doubled commas: Check for blank cells, existing punctuation, or spaces in the source values. TEXTJOIN can skip empty cells, but it does not remove punctuation that is already in a cell.
  • Formula shown instead of a result: Confirm the cell is not formatted as Text, then re-enter the formula. Also check that it begins with an equals sign and that Show Formulas has not been turned on.

Frequently Asked Questions

How do I concatenate cells with a comma and a space?
For two cells in A2 and B2, use =A2&", "&B2. The quoted text supplies both the comma and the following space.

How do I combine a column with commas and ignore blanks?
With the values in A2:A20, use =TEXTJOIN(", ",TRUE,A2:A20). It joins the nonempty values using comma-space separators in Excel versions that include TEXTJOIN.

Can I use CONCATENATE to add a comma?
Yes. With values in A2 and B2, =CONCATENATE(A2,", ",B2) includes the separator as a text argument. CONCATENATE is retained for compatibility, but CONCAT or TEXTJOIN is usually a better choice for newer workbooks.

Why does my joined date show a number?
Excel stores real dates as serial values. With a date in A2, use =TEXT(A2,"mmmm d, yyyy") to create a date string in that format, then join that text to the other values. Confirm the cell contains a real date if the result still looks wrong.

Can I use a different separator instead of a comma?
Yes. Replace the delimiter text with the separator you want, such as a semicolon or slash. For TEXTJOIN, the delimiter is the first argument; for an ampersand formula, put the desired text between quotation marks.

Will the combined result update when the source cells change?
Yes, a formula recalculates when its referenced cells change, subject to the workbook’s calculation settings. If you paste the result as values, it becomes fixed text and no longer updates from those source cells.

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.