Skip to content
English
  • There are no suggestions because the search field is empty.

JOIN Operation

How to use the JOIN operation in formulas

Definition

Example

Syntax Guide

Formula In Use


Definition

The JOIN operation lets you concatenate, or link, values with a delimiter. 


Example

JOIN(["a", "b"], "-")

Result:
a-b


Syntax Guide

JOIN([values], delimiter)

values - The values to be appended using delimiter, confined by a set of brackets [ ]

delimiter - The character or string to place between each concatenated value

ℹ️  The delimiter may be specified as blank, e.g. JOIN(["1","2","3"],) 

In this case the result would be: 1 2 3


Formula In Use

JOIN-1

 


What's Next?