Excel Column to Comma-Separated List: Easy Methods

If your values are in A2:A20, enter =TEXTJOIN(", ",TRUE,A2:A20) in an empty cell to turn the column into one comma-separated list. For example, Red, Blue, and Green in the first three cells produce Red, Blue, Green; blank cells are skipped.

Use TEXTJOIN for a quick list

TEXTJOIN is the simplest choice for combining a range because it adds the separator between items and can ignore empty cells. In Microsoft 365 for Windows, select a blank cell outside your source data, type the formula from the opening example, and press Enter. The result appears in that cell as text; the original column remains unchanged.

Replace A2:A20 with the range that contains your values. If the values are in column C from row 5 through row 40, for instance, use C5:C40. Keep the range as specific as practical rather than selecting an entire column: a bounded range is easier to check and avoids including a heading or unrelated data farther down the sheet.

TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. The formula works in Excel for the web and Excel for Mac as well as Windows, although menu placement and some keyboard shortcuts differ across platforms. If your Excel installation uses semicolons as formula argument separators because of regional settings, it may display formulas differently; the examples here use commas.

How TEXTJOIN works

The formula has three parts: the delimiter, a setting for empty cells, and the values to combine. In the example, the delimiter is a comma followed by a space, TRUE tells Excel to ignore empty cells, and A2:A20 is the source range. Change the delimiter to control exactly how the output reads.

The formula creates one result in one cell; it does not split, move, or delete the original entries. Because it refers to the source range, the result updates when a value in that range changes. This makes it useful for a list that needs to stay connected to a working spreadsheet, such as selected product names, email addresses, or category labels.

A cell can hold up to 32,767 characters. If a very large range produces a longer combined string, Excel cannot store the complete result in one cell. For an unusually long list, use a file export or another data-handling method rather than trying to place all the text in a single cell.

Choose the separator you need

A comma and a space is readable for people. If another system expects commas with no spaces, use the same range and ignore-empty setting with a comma alone: =TEXTJOIN(",",TRUE,A2:A20). With Apple, Pear, and Plum in the source cells, that version returns Apple,Pear,Plum.

You can also use a different delimiter when the destination calls for it. A semicolon-separated result uses =TEXTJOIN("; ",TRUE,A2:A20), while a vertical-bar-separated result uses =TEXTJOIN(" | ",TRUE,A2:A20). For those formulas, assume the same source range, A2:A20; with Apple, Pear, and Plum in that range, the respective results are Apple; Pear; Plum and Apple | Pear | Plum. Choose a separator that will not be confused with characters already inside the values.

For a simple list intended for an email or note, spaces after commas usually improve readability. For a system import, check its instructions first: it may require no spaces, a different delimiter, or a particular file format. A list that looks right to a person is not automatically formatted correctly for every application.

Handle blank cells and extra spaces

With the TRUE setting, TEXTJOIN skips genuinely empty cells instead of producing repeated separators. If A2 contains North, A3 is empty, and A4 contains South, the output is North, South, not North, , South. This is useful when the source range has gaps or formulas that return an empty string.

Cells containing spaces are not necessarily empty to Excel. A cell with one or more space characters can therefore create an item that looks blank in the result. TEXTJOIN also does not automatically remove leading or trailing spaces from a name. If the output looks oddly spaced, inspect the source cells and clean the entries before combining them; the TRIM function can remove extra ordinary spaces in a helper column.

Errors in the source range can also affect the result. If one of the referenced cells contains an error such as #N/A, TEXTJOIN may return that error instead of a list. Find and resolve the source error, or decide explicitly how it should be represented before building the combined text. Ignoring empty cells does not mean ignoring errors.

Remove duplicates or change the order

TEXTJOIN includes repeated values as many times as they occur. If A2:A5 contains Red, Blue, Red, and Green, a basic join returns Red, Blue, Red, Green. To list each distinct value once in Microsoft 365 or Excel 2021 and later, assume those four entries are in A2:A5 and use =TEXTJOIN(", ",TRUE,UNIQUE(A2:A5)). The result is Red, Blue, Green.

UNIQUE keeps the order in which distinct values first appear in the source; it does not alphabetize them. If the list needs sorting, sort the source range first, or use a separate sorting step before joining. Be careful with the Data > Remove Duplicates command: it changes the selected source data, whereas the formula approach creates a distinct list in the result without deleting the original entries.

Distinguish a comma list from a CSV file

A comma-separated string made with TEXTJOIN is not necessarily a correctly encoded CSV record. If a value itself contains a comma, such as a city-and-state entry, a plain join does not add quotation marks to protect that comma. Quotes and line breaks inside values create further formatting issues. A receiving program may then interpret one value as multiple fields.

If you only need a readable line of text, a basic TEXTJOIN result may be all you need. If you need to transfer a table as a CSV file, use Excel’s file-saving or export options and select a CSV format. Exporting a workbook table preserves the idea of separate fields far more reliably than manually joining a column into one cell. Check the destination’s expected encoding and delimiter too, since those can vary by application and region.

Keep the result as text or make it static

A formula result is dynamic: edits to the referenced cells can change the list. That is helpful while the source is being maintained, but a form, message, or import process may need a fixed snapshot. Copy the result cell, then use Home > Paste > Values to replace a formula with its displayed text. This leaves the original source column intact.

For a keyboard copy, use Ctrl+C on Windows or Command+C on Mac. The paste-values command is available from the ribbon; its exact shortcut and menu presentation can vary by Excel version and platform. Before replacing a formula, confirm that you are pasting into the intended cell and that you no longer need the result to update automatically.

When a manual formula is useful

For only a few fixed cells, the ampersand operator can join values without TEXTJOIN. Assume A2 contains Red, A3 contains Blue, and A4 contains Green; enter =A2&", "&A3&", "&A4 to return Red, Blue, Green. This approach is straightforward for a tiny, known set of cells, but every added item requires editing the formula. It also does not conveniently skip blanks, so a range-based TEXTJOIN formula is usually easier to maintain.

Manual concatenation is not a better method just because it uses a familiar operator. If the source list grows, changes length, or contains blanks, a formula that names every cell becomes fragile. Choose the simplest formula that matches the size and behavior of the data rather than building a long chain for a range that TEXTJOIN can handle directly.

Frequently Asked Questions

How do I combine an entire Excel column into one comma-separated cell?
Use TEXTJOIN with the column as the range, but a full-column reference may include a header and unrelated values and can make the calculation less efficient. A practical choice is a bounded range such as A2:A500, or the relevant column in an Excel Table.

How do I make a comma-separated list without spaces?
Use a comma as the delimiter instead of a comma followed by a space. For values in A2:A20, =TEXTJOIN(",",TRUE,A2:A20) produces output such as Red,Blue,Green.

Can Excel ignore blank cells while joining a column?
Yes. Set TEXTJOIN’s ignore-empty argument to TRUE, as in the main example. That skips empty cells, but it does not remove spaces inside a cell, remove duplicates, or suppress errors.

Can I create the list in alphabetical order?
TEXTJOIN alone preserves the source order. Sort the source values before joining, or use a sorting function available in your Excel version. UNIQUE by itself removes duplicates but does not alphabetize the result.

Why does my comma-separated list show a number instead of a date?
Excel stores dates as numbers, and joining values can expose their underlying numeric representation rather than the date display you see in the source cell. Format dates as text in a helper column using the date format required for the destination, then join that text column.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.