# TEXTJOIN function in Excel

> TEXTJOIN joins a list of values with the same delimiter between each one, and can skip blanks.

Source: https://spreadsheetpractice.com/functions/textjoin · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** TEXTJOIN joins a list of values with the same delimiter between each one, and can skip blanks.
- **Syntax:** `=TEXTJOIN(delimiter, ignore_empty, text1, ...)`
- **Most common use:** `=TEXTJOIN("; ",TRUE,A2:A4)` returns maya@acme.com; raj@globex.io (Emails for one To: line, skipping the blank)
- **Available in:** Excel 2019 and later, including Microsoft 365
- **Category:** [Text functions](https://spreadsheetpractice.com/functions/category/text)
- **Returns:** One text string, up to 32,767 characters.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

TEXTJOIN joins a list of values with the same delimiter between each one, and can skip blanks. It turns a column of emails into one semicolon-separated line, or a row of tags into "red, large, cotton", without a chain of & signs.

## Syntax

`=TEXTJOIN(delimiter, ignore_empty, text1, ...)`

| Argument | Required? | What it is |
|---|---|---|
| `delimiter` | Required | The text to put between items, such as ", " or "; ". Use "" for none. |
| `ignore_empty` | Required | TRUE skips empty cells. FALSE keeps them, which leaves double delimiters. |
| `text1` | Required | The values or ranges to join. Add more after it, separated by commas. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | `=TEXTJOIN("; ",TRUE,A2:A4)` | maya@acme.com; raj@globex.io | Emails for one To: line, skipping the blank |
| E3 | `=TEXTJOIN(", ",TRUE,B3:D3)` | blue, large, wool | A row of tags as one readable list |
| E4 | `=TEXTJOIN(", ",FALSE,B2:D2)` | red, , cotton | With FALSE, the empty tag leaves a double comma |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Email | Tag 1 | Tag 2 | Tag 3 | Result |
| 2 | maya@acme.com | red |  | cotton | maya@acme.com; raj@globex.io |
| 3 | raj@globex.io | blue | large | wool | blue, large, wool |
| 4 |  | green | small |  | red, , cotton |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NAME? in older versions | TEXTJOIN needs Excel 2019 or later. In older versions, join with & and handle blanks with IF. |
| Double delimiters | Set ignore_empty to TRUE. Cells where a formula returns "" are skipped too. |
| #VALUE! on long lists | The result can't exceed 32,767 characters, the most a cell can hold. |

## Tips

- Combine it with FILTER to list only matching items: =TEXTJOIN(", ",TRUE,FILTER(A2:A20,B2:B20="East")).
- Use CHAR(10) as the delimiter and turn on Wrap Text for one item per line.

## Related functions

- [CONCAT](https://spreadsheetpractice.com/functions/concat): CONCAT joins text from several cells or whole ranges into one string.
- [CONCATENATE](https://spreadsheetpractice.com/functions/concatenate): CONCATENATE joins up to 255 text items into one string.
- [FILTER](https://spreadsheetpractice.com/functions/filter): FILTER returns only the rows of a range that pass a test, such as every order from the West region.
- Comparison: [CONCAT vs TEXTJOIN vs &](https://spreadsheetpractice.com/functions/compare/concat-vs-textjoin)

## Questions

### How do I combine a column into one cell with commas?

Use =TEXTJOIN(", ",TRUE,A2:A50). TRUE skips the blank cells.

### What is the difference between TEXTJOIN and CONCAT?

TEXTJOIN puts a delimiter between items and can skip blanks. CONCAT runs everything together with nothing in between.

## Practice

A graded TEXTJOIN exercise ("One-cell list") is on [the TEXTJOIN page](https://spreadsheetpractice.com/functions/textjoin). It is checked instantly, then re-checked on changed data.

Lessons that use TEXTJOIN:

- [Lesson 19: Joining text](https://spreadsheetpractice.com/learn/joining-text) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
