JOIN practice

JOIN concatenates the values of a range with a delimiter between them, in Google Sheets. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

JOIN(delimiter, value_or_array1, ...)

What people get wrong

Feed it a FILTER to join only the rows that meet a condition.

Google Sheets exercise that use JOIN

• Join the confirmed namesLevel 5Pro

Often used together with: FILTER