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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)Excel 2019 / 365 |
| Google Sheets | ✔ Built in | TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...]) |
| Airtable | ≈ Workaround | ARRAYJOIN(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 in | join(list, separator)Also the list method list.join(", "). Add .filter(current != "") first to skip empty items, the same as ignore_empty = TRUE. |
| 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
| Argument | What it means |
|---|---|
delimiter | Text placed between items, such as ", " or CHAR(10) for a line break. |
ignore_empty | TRUE skips empty cells; FALSE keeps them, so two delimiters appear next to each other. |
text1, ... | The values or ranges to join. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=TEXTJOIN(", ", TRUE, A2:A6) | Ada, Grace, Linus | Blank cells in the range are skipped. | |
=TEXTJOIN("-", TRUE, "2026", "11", "19") | 2026-11-19 | Separate values work as well as ranges. | |
=TEXTJOIN(", ", FALSE, "a", "", "b") | a, , b | With FALSE, the empty value keeps its place. | |
=TEXTJOIN(", ", TRUE, FILTER(A2:A20, B2:B20="Yes")) | Names marked Yes | Join 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).