Concatenate an Excel List: Join Values With Delimiters

To concatenate an Excel list into one cell, use TEXTJOIN: with the values in A2:A6, enter =TEXTJOIN(", ",TRUE,A2:A6). It joins the nonblank values with a comma and a space; for example, Ana, Ben, Dan, and Eva become Ana, Ben, Dan, Eva.

What “concatenate a list” means in Excel

Concatenating means combining text or values into a single result. When people ask how to “concat an Excel list,” they usually mean taking entries in a column or row and joining them into one cell, perhaps as a comma-separated list for an email, report, label, or another application.

Excel offers several ways to do this. TEXTJOIN is generally the most convenient for a range because you can specify a separator and choose whether empty cells should be skipped. CONCAT joins values without inserting a separator. The ampersand operator, &, is useful when combining a small number of specific cells or adding fixed text around a value.

These formulas create a result in a cell; they do not merge the original cells or delete the source list. That distinction matters: the source values remain available for later edits, and the joined result updates when a referenced value changes.

Use TEXTJOIN for a list with separators

TEXTJOIN takes three essential parts: the delimiter to place between values, a TRUE or FALSE choice about ignoring empty cells, and the text or range to combine. It is available in Excel 2019 and later, including Microsoft 365. For a comma-separated list, a comma followed by a space is usually easier to read than a comma alone.

With Ana in A2, Ben in A3, a blank A4, Dan in A5, and Eva in A6, enter this in another cell:

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

The result is Ana, Ben, Dan, Eva. The first argument, ", ", is inserted between retained values. The second argument, TRUE, tells Excel to ignore empty cells. The range argument, A2:A6, identifies the list. If you instead use FALSE, the empty cell is not skipped, so its position can produce adjacent delimiters.

Change the delimiter to suit the destination. For the same values, =TEXTJOIN("; ",TRUE,A2:A6) produces Ana; Ben; Dan; Eva. A line break can separate items vertically within a cell: with the same list in A2:A6, use =TEXTJOIN(CHAR(10),TRUE,A2:A6). Turn on Wrap Text for the result cell so the line breaks are visible. On Windows, the line-break character is CHAR(10); Excel for Mac also supports this formula.

Use CONCAT when no delimiter is needed

CONCAT combines text from a range or set of values but does not add punctuation or spaces between them. With Ana, Ben, Dan, and Eva in A2:A5, enter =CONCAT(A2:A5) to return AnaBenDanEva. This can work for joining fragments that already contain their own spaces or punctuation, but it is usually not the best choice for a readable list.

If spaces are already part of the source values, CONCAT preserves them. For example, with North in A2 and Office in A3, =CONCAT(A2:A3) returns North Office. Watch for accidental leading or trailing spaces in source cells, though: they can make results look inconsistent or cause problems in later matching and comparison tasks.

For newer workbooks, CONCAT replaces the older CONCATENATE function for ordinary joining. CONCATENATE remains available for compatibility with older Excel files, but it is less convenient for ranges. CONCAT and TEXTJOIN are supported in modern Excel; if a workbook must work in a very old Excel release, check function compatibility on the computers that will open it.

Use the ampersand for selected cells and labels

The & operator joins specific values in the order you write them. It is a good option for a short combination, especially when you need to place a fixed label or punctuation between two cells.

With a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2. If A2 contains Maya and B2 contains Chen, the result is Maya Chen. The formula explicitly supplies a space between the names; without &" "&, the result would run them together.

For a longer list, you can chain more cells, but each additional item makes the formula harder to maintain. With values in A2, B2, and C2, =A2&", "&B2&", "&C2 returns a comma-separated result. If the number of list items may change, use TEXTJOIN with a range instead of extending an ampersand formula by hand.

Choose the right method for your task

The best approach depends on whether you need a separator, whether you are joining a range or only a few cells, and whether blank cells matter. As a quick guide:

Choose TEXTJOIN to combine a range with a delimiter and optionally skip blanks.
Choose CONCAT to combine a range without adding anything between its values.
Choose & for a few selected cells, fixed labels, or custom text between values.
Choose CONCATENATE only when maintaining a legacy formula or workbook requires it.

These functions return a text result, even when some source cells contain numbers. If you need the joined result to remain useful for calculations, keep the original numeric values in separate cells and treat the concatenated output as a display or export string. Once numbers are combined with text separators, Excel cannot use that single text string as a normal numeric range.

Control spaces, blanks, and number formats

A formula can join exactly what is stored in a cell, including extra spaces. If a name appears with an unwanted gap, inspect the source for leading or trailing spaces. You can clean a single cell’s surrounding ordinary spaces with TRIM: with a name in A2, =TRIM(A2) returns the name with repeated internal spaces reduced to single spaces and leading or trailing spaces removed. TRIM does not remove every kind of invisible character, so copied data may sometimes need additional cleanup.

There is a difference between a genuinely empty cell and a formula that returns an empty string, such as ="". TEXTJOIN with its ignore-empty setting can skip empty text values, but a cell containing spaces is not empty. If a list appears to have unexplained separators, check for cells containing spaces or formulas rather than assuming they are blank.

Numbers and dates can also need attention. A date is stored by Excel as a number with a display format. When joined into text, the result may not preserve the date’s familiar cell formatting. If you need a specific date appearance, format the value explicitly with TEXT before joining it. For example, with a date in A2, =TEXT(A2,"mmm d, yyyy") returns a display string such as Nov 2, 2026 when A2 contains that date. The exact displayed date depends on the value in A2 and your format choice.

Common problems and how to fix them

If Excel displays the formula itself instead of the joined result, first check that the cell is not formatted as Text. Change its number format to General, then edit and re-enter the formula. Also check whether Show Formulas is enabled; on Windows, Ctrl+` toggles formula display. On many Mac keyboards, the equivalent key combination uses Control+`, though keyboard layouts can differ.

If a formula returns #NAME?, confirm that the function name is spelled correctly and that the Excel version supports it. If you use a comma where your Excel regional settings expect a semicolon between function arguments, Excel may reject the formula; use the argument separator required by your installation. The examples here use commas as specified for standard English-language Excel syntax.

If the output has unwanted punctuation, review the delimiter and the ignore-empty setting. If it is missing spaces, include them inside the delimiter or between ampersand terms. If it looks cut off or runs together, check the source values and the result cell’s display width. The formula result is text in one cell, so it may need a wider column or Wrap Text to display comfortably.

Make the joined result static or share it

A formula-based result recalculates when its source cells change. That is useful for a live report, but it may not be what you want when sending a fixed snapshot or pasting the result into another system. To keep the current output while removing the formula, copy the result cell and use Paste Special > Values. In Excel for Microsoft 365 on Windows, the Home tab includes Paste options; the Paste Special dialog can also be opened with Ctrl+Alt+V. On Mac, use the Paste Special command or its available shortcut for your version and keyboard settings.

Before replacing a formula with its value, make sure you will not need the live connection to the source list. A practical workflow is to keep the original list and formula on one sheet, then paste a values-only copy into the file or message that needs a fixed string.

Frequently Asked Questions

How do I combine an Excel column into one cell with commas?
With the list in A2:A20, use =TEXTJOIN(", ",TRUE,A2:A20). It joins the nonblank entries with a comma and a space.

Can Excel concatenate a list and ignore blank cells?
Yes. In TEXTJOIN, set the second argument to TRUE, as in =TEXTJOIN(", ",TRUE,A2:A20). Cells that are truly empty or return empty text are skipped; cells containing spaces are not necessarily skipped.

What is the difference between CONCAT and TEXTJOIN?
CONCAT joins values without a delimiter. TEXTJOIN lets you specify a delimiter and whether to ignore empty cells, making it more suitable for a readable list.

Can I put each joined item on a new line?
Yes. Use =TEXTJOIN(CHAR(10),TRUE,A2:A20) and enable Wrap Text on the result cell. Each retained value then appears on a separate line inside that cell.

Does concatenating cells change the original list?
No. A formula creates a separate result and leaves the source cells intact. To replace the formula with a fixed result, copy the output and paste values.

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.