All functions / Text

TEXTJOIN

Joins text with a separator between each item.

Syntax

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

Arguments

• delimiter: What to put between items, e.g. ", ".
• ignore_empty: TRUE to skip empty cells.
• text: Text, cells or ranges to join.

Example

=TEXTJOIN(", ", TRUE, A2:A6) → "Ann, Ben, Cy"

Practise it

• Joining text