TEXTJOIN practice

TEXTJOIN joins several texts with a delimiter, optionally skipping empty cells. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

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

What people get wrong

The ignore_empty argument is what keeps double commas out of a joined list.

Google Sheets exercise that use TEXTJOIN

• Address without gapsLevel 5Pro