Text

TEXTJOIN function playground

Joins text with a separator you choose, optionally skipping empty cells.

Available in: Excel 2019 and later, Microsoft 365Read the full tutorial →

The playground runs in your browser. Nothing you type is sent anywhere.

How TEXTJOIN works

TEXTJOIN puts the delimiter between each item and joins them into one piece of text.

With ignore_empty set to TRUE, blank cells disappear cleanly. With FALSE you get two delimiters in a row where a cell is empty (the last name in row 6 is blank).

Syntax

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

Argument	What it means
`delimiter`required	Text to put between items, such as ", ".
`ignore_empty`required	TRUE skips empty cells; FALSE keeps them.
`text1`required	The first text, cell or range.
`text2, ...`optional	More text, cells or ranges.

Examples

Formula	What it does	Result
`=TEXTJOIN(", ",TRUE,B2:B6)`	All first names in one cell.	Grace, Omar, Lily, Jonas, Rosa
`=TEXTJOIN(" ",TRUE,B2:C2)`	First and last name with a space.	Grace Kim · Omar Haddad · Lily Chen · Jonas Berg …
`=TEXTJOIN(", ",FALSE,C2:C6)`	FALSE keeps the blank last name, so the list ends with a stray comma.	Kim, Haddad, Chen, Berg,
`=TEXTJOIN(" / ",TRUE,B2,C2,A2)`	Mix single cells in any order.	Grace / Kim / PRD-2026-0042

Common mistakes

Forgetting ignore_emptyIt is required. TRUE is usually what you want.

Result too longA cell can hold 32,767 characters; joining a huge range returns #VALUE!.

Learn more

Download the example workbook (.xlsx)

The workbook has the same sample data and formulas, plus a practice sheet.

Read the full tutorial →