JOIN

When to use it

When should I use JOIN instead of CONCATENATE or TEXTJOIN?

Use JOIN when you want to combine multiple values or an array into a single string separated by a delimiter; it is simpler than TEXTJOIN for flat lists without blank-filtering needs.

Used in

operations · sales

Syntax

JOIN(delimiter, value1, ...)