Lesson 26 · Text
TEXTJOIN Function
Practice TEXTJOIN in Google Sheets: join a range of text with a delimiter and skip empty cells.
Join all the tags in A2:A7 into one cell separated by ", ", skipping blanks. Answer in C2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
Joining a whole range with TEXTJOIN
=TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])
TEXTJOIN puts a separator between every item, which & can't do neatly for a whole range.
- delimiter: what goes between items, e.g.
", "
- ignore_empty:
TRUE skips blank cells so you don't get doubled separators
=TEXTJOIN(", ", TRUE, A2:A7) → urgent, design, client