In Excel 2016 and later, the formula =TEXTJOIN(",", TRUE, A1:A10) converts the values in cells A1 through A10 into a single comma-separated string, such as apple,banana,cherry, in any destination cell where the result should appear. The first argument is the delimiter, here a single comma, the second argument is a boolean that controls whether empty cells are skipped, and the third argument is the range to join. Set the second argument to TRUE so blank rows do not produce stray commas, and switch the range to a larger range such as A1:A1000 when you do not know how many populated rows the column actually contains. TEXTJOIN handles text, numbers, and date cells the same way, and it returns one text value that you can paste into another column, a search box, an email form, or a SQL editor. For older Excel versions without TEXTJOIN, a common workaround is to type =A1&", "&A2&", "&A3 in the destination cell, but that approach has no native blank-skipping and quickly becomes awkward for more than a handful of rows.
The Excel formula: =TEXTJOIN(",", TRUE, A1:A10)
TEXTJOIN was added in Excel 2016 and works in Excel 2019, Excel 2021, Excel 2024, and Microsoft 365. The full signature is =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …), so you can pass a single range, several individual cells, or a mix of both. For a column of names in A2:A200, the formula becomes =TEXTJOIN(",", TRUE, A2:A200). The TRUE in the second slot is what tells Excel to drop empty cells without leaving an empty slot where they used to be, which is the most common reason a hand-built concatenation looks like apple,,banana, with extra commas.
To put the formula into practice on a small example, picture cells A1 through A6 holding Apple, blank, Banana, Cherry, blank, Date. Writing =TEXTJOIN(",", TRUE, A1:A6) in cell B1 and pressing Enter produces the string Apple,Banana,Cherry,Date: four visible values joined by three commas, with the two blank rows silently filtered out. If you then write =LEN(B1) to count characters, Excel returns 24, which matches the four names plus the three separator characters. That tiny check is a reliable way to confirm that blank rows have not been counted before you copy the result somewhere else.
A few variations cover common needs. To separate with a comma and a space, change the first argument to ", ". To use a semicolon instead of a comma in regions where the decimal separator is a comma, change it to ";". To join text from two columns side by side, pass both ranges: =TEXTJOIN(",", TRUE, A2:A50, B2:B50). The result is a single string where each cell of column A is followed by the corresponding cell of column B, separated by a comma, which is helpful for building SQL-style value pairs. Copy the result with Ctrl+C and Paste Special as values when you need a plain string rather than a live formula.
When TEXTJOIN output goes wrong on real values
TEXTJOIN is excellent at joining values with a separator, but it does nothing to escape the values themselves. If a cell contains a literal comma, that comma is simply emitted into the output string, so a column with two names Smith, Jane and Doe, John joined with TEXTJOIN produces "Smith, Jane","Doe, John" only if you add quoting back yourself. Otherwise the output looks like four values, not two, which corrupts anything downstream that tries to parse the list back into fields. The same problem appears with double quotes: a cell containing the text 6" bolt is joined verbatim, which breaks CSV, JSON, and many shell contexts that treat an unescaped quote as the start of a string.
There is no built-in TEXTJOIN option to wrap each value in double quotes or to double embedded quotes, because those behaviors are properties of CSV, not of cell joining. Excel does offer the older CONCATENATE function and the & operator, but neither solves the quoting problem either. When the column contains values with commas, double quotes, semicolons, or line breaks, you either need to add a helper column that wraps and escapes each value before joining, or you need a tool that performs the CSV quoting for you.
This is the practical gap that a dedicated comma-list builder fills. A tool built specifically for the column-to-comma task can apply CSV-style quoting by default, double every embedded double quote, and emit a string that any CSV-aware application can re-parse into the original values without losing boundaries.
Building a quote-safe list in your browser
The Column to Comma Separated List tool runs the same conversion in a single browser tab and applies the CSV quoting that TEXTJOIN cannot. It accepts one value per line, trims and deduplicates on request, and emits a read-only output box with a precise value count and a Copy button. Use it whenever your Excel column contains names with commas, descriptions with quotes, product codes with mixed punctuation, or any other case where the joined string needs to round-trip through another parser.
- Copy the column from Excel with Ctrl+C, leave the heading behind, and paste the values into the input box one per line.
- Leave Trim surrounding spaces enabled so accidental leading or trailing spaces on a copied cell do not change a value.
- Leave Remove blank lines enabled so empty rows from the source column do not appear in the output.
- Enable Remove duplicate values only when repeated rows truly have no meaning in the destination; the comparison is case-sensitive, so Apple and apple stay distinct.
- Keep CSV-quote every value enabled; the tool wraps each value in double quotes and doubles every embedded double quote, which protects values such as Smith, Jane and 6" bolt.
- Click Convert column, compare the displayed value count against your expected number of rows, and inspect any punctuation-heavy entries.
- Click Copy result and paste the quoted string into the spreadsheet, the SQL editor, the email field, or the config file where it belongs.
The tool accepts Windows CRLF, older carriage-return, and Unix line-feed line breaks, so lists copied from Excel, Notepad, VS Code, or a plain email are all parsed the same way without manual cleanup. The conversion runs in the current page, so pasted values are not uploaded and reloading the tab clears both the input and the output.
Excel formula vs browser tool at a glance
| Capability | Excel TEXTJOIN | Column to Comma Separated List |
|---|---|---|
| Output delimiter | Any single character or short string you pass | Comma and space by default; quoted form uses only commas |
| Empty-cell handling | Optional, set by the second argument | Optional, controlled by the Remove blank lines toggle |
| Trims surrounding spaces per value | No | Yes, controlled by a toggle |
| Wraps each value in double quotes | No | Yes, by default |
| Doubles embedded double quotes | No | Yes, by default |
| Removes duplicate values | No built-in option | Yes, case-sensitive, after trimming |
| Result counter for verification | Requires a separate LEN or COUNTA formula | Displayed next to the output |
| Paste size cap | Limited by Excel's cell size, 32,767 characters | 500,000 input characters, 10,000 lines |
| Where the work runs | Inside the worksheet | Inside the browser tab; nothing is uploaded |
A useful rule of thumb is to use TEXTJOIN when the column contains only simple identifiers that will be read by a human, and switch to the browser tool when the output feeds another parser such as a CSV import, an API call, or a SQL IN list. The two approaches are complementary rather than competing: the tool accepts any pasted list and does not depend on Excel running, so it works just as well with values exported from Google Sheets or copied from a plain text file.
Practical limits you should plan around
Excel TEXTJOIN is constrained by the destination cell's size, which tops out at 32,767 characters in modern Excel. A column of long names joined with commas and spaces can blow past that ceiling surprisingly quickly, at which point Excel returns the #VALUE! error rather than truncating. When the working list is modest, TEXTJOIN is the right tool, but when the destination is a CSV-aware application, the safer path is to copy the column out of Excel and run it through a browser tool that does not have the 32,767 character limit and that applies the right quoting on the way through.
The Excel Column to Comma Separated List in 3 Steps guide walks the copy, paste, and convert motion in more detail if you want a tighter workflow that begins in the spreadsheet itself. For SQL IN clauses, JSON arrays, URL query parameters, and command-line arguments, neither TEXTJOIN nor a CSV-quoted list is enough on its own, because each of those destinations has its own escape and quoting rules, so use a formatter purpose-built for that destination instead.
If deduplication matters, remember that the browser tool's match is exact and case-sensitive only after trimming, which is deliberate because silently normalizing case could change product names, error codes, and identifier strings that rely on capital letters for meaning. The two safeguards that catch most mistakes are right there in the output area: the count of values, which should match the number of rows you expect after filtering, and the quoted text itself, which makes any preserved punctuation such as a comma or an embedded double quote visually obvious before you paste it anywhere important.
Related reading: Compare Two Lists for Matches in One Local Pass.