TEXTJOIN()
Joins text with a delimiter between each item, and can skip blank cells.
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)TEXTJOIN combines CONCAT's ability to join whole ranges with a delimiter placed between every item — a comma-separated list from a column is a single formula: TEXTJOIN(", ", TRUE, A2:A10).
Setting ignore_empty to TRUE skips blank cells instead of leaving an extra delimiter where they would have been.
Arguments
- delimiter
- The text to insert between each joined item.
- ignore_empty
- TRUE to skip blank cells, FALSE to include them as empty items.
- text1
- The first text value, cell, or range to join.
- text2, ...optional
- Additional text values, cells, or ranges to join.
Examples
=TEXTJOIN(", ", TRUE, A2:A10)→Alex, Priya, Sam, Jordan
A comma-separated list from a column, skipping any blanks.