Google Sheets function
TEXTJOIN function in Google Sheets
TEXTJOIN in Google Sheets combines text from values or ranges and inserts a chosen delimiter between each item. It can ignore empty cells or include them. Use TEXTJOIN to build comma-separated lists, labels, addresses, or other text assembled from several cells.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
delimiter | Yes | The text inserted between combined items. |
ignore_empty | Yes | TRUE to skip empty cells or FALSE to include them. |
text1 | Yes | The first text value or range to combine. |
text2, ... | No | Additional text values or ranges to combine. |
Examples
Join attendee names
| A | |
|---|---|
| 1 | Attendee |
| 2 | Ana |
| 3 | Ben |
| 4 | Cara |
=TEXTJOIN(", ",TRUE,A2:A4)Result: Ana, Ben, Cara
TEXTJOIN combines the three names and places a comma and space between them.
Common mistakes
Leaving a text delimiter outside quotation marks.
Write the delimiter as a string, such as ", ".
Setting ignore_empty to FALSE when blank cells should disappear.
Use TRUE to skip empty cells without adding extra delimiters.