Spreadsheet formulas explained, side by side

TEXTJOIN Function in Excel, Google Sheets, Airtable & Notion

TEXTJOIN joins many values into one string with a delimiter between them, such as a comma, and can skip empty cells. It turns a column of names into “Ada, Grace, Linus”.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inTEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
Excel 2019 / 365
Google Sheets✔ Built inTEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])
Airtable≈ WorkaroundARRAYJOIN(values, ", ")
No TEXTJOIN. In a rollup field, or on a lookup field, use ARRAYJOIN(values, ", "), and ARRAYJOIN(ARRAYCOMPACT(values), ", ") to drop blanks. For a few fields of one record, chain them with &, as the tester does.
Notion✔ Built injoin(list, separator)
Also the list method list.join(", "). Add .filter(current != "") first to skip empty items, the same as ignore_empty = TRUE.
Try TEXTJOIN with your own values
One item per line
Result (as Excel & Google Sheets return it)
Ada, Grace, Linus 17 characters
Your formula, ready to paste
Excel=TEXTJOIN(", ", TRUE, A2:A5) open excel.new ↗
Google Sheets=TEXTJOIN(", ", TRUE, A2:A5) open sheets.new ↗
Airtable
workaround
"Ada" & ", " & "Grace" & ", " & "Linus"
Notion["Ada", "", "Grace", "Linus"].filter(current != "").join(", ")

Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.

Name
Ada

Grace
Linus

Arguments

ArgumentWhat it means
delimiterText placed between items, such as ", " or CHAR(10) for a line break.
ignore_emptyTRUE skips empty cells; FALSE keeps them, so two delimiters appear next to each other.
text1, ...The values or ranges to join.

Examples

FormulaResultWhyCopy
=TEXTJOIN(", ", TRUE, A2:A6)Ada, Grace, LinusBlank cells in the range are skipped.
=TEXTJOIN("-", TRUE, "2026", "11", "19")2026-11-19Separate values work as well as ranges.
=TEXTJOIN(", ", FALSE, "a", "", "b")a, , bWith FALSE, the empty value keeps its place.
=TEXTJOIN(", ", TRUE, FILTER(A2:A20, B2:B20="Yes"))Names marked YesJoin only the rows that match (Excel 365 and Google Sheets). See FILTER.

Examples use Excel / Google Sheets syntax unless noted.

How TEXTJOIN works

TEXTJOIN replaces long chains like =A2&", "&A3&", "&A4. Give it a delimiter, say whether to skip blanks, and pass one or more ranges. With ignore_empty set to TRUE you don't get doubled commas where a cell is empty, which is what you want for address lines, tag lists and email recipient lists.

It works with array results, so =TEXTJOIN(", ", TRUE, FILTER(...)) or =TEXTJOIN(", ", TRUE, UNIQUE(A2:A50)) builds a list of only the matching or distinct values. The result is limited to 32,767 characters; longer results return #VALUE!. TEXTJOIN needs Excel 2019 or Microsoft 365. In older Excel, chain values with &.

Airtable formulas only see one record, so joining a whole column means a rollup (or a formula on a lookup field) with ARRAYJOIN(values, ", "). Wrap the values in ARRAYUNIQUE or ARRAYCOMPACT to remove duplicates or blanks. In Notion, lists have a join() method: prop("Tags").map(current.name()).join(", "), or .filter(current != "") first to skip blanks. (Swap .name() for the property your list items use.)

Frequently Asked Questions

How do I join a column with commas?
Use =TEXTJOIN(", ", TRUE, A2:A100). In older Excel without TEXTJOIN, chain the cells with & or copy the column and use Paste Special → Transpose plus CONCAT.
How do I join values on separate lines?
Use CHAR(10) as the delimiter and turn on Wrap text: =TEXTJOIN(CHAR(10), TRUE, A2:A6).

Part of the Text functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.