Skip to main content
📌 More functions: see the Formula function reference.

​
1 Basics

TEXTJOIN joins multiple text strings into one. Unlike simple concatenation, TEXTJOIN lets you set a delimiter and optionally skip empty cells.

​
Syntax

delimiter: a string or a reference to a valid string — may be empty. If empty, texts are concatenated directly. ignore_empty: a boolean. If TRUE, empty cells in the text args are skipped. text1: any text — a string or an array of strings from a range. text2: more text.

​
Examples

Single record (row): Field 1 = “Apple”, Field 2 = “Banana”, Field 3 = empty, Field 4 = “Grape”.

​
Example 1: Skip Empty

Result: Apple, Banana, Grape

​
Example 2: Keep Empty

Result: Apple, Banana, , Grape With TEXTJOIN, combine info from multiple sources into a readable, processable string — control delimiter and empty handling.

​
2 Scenario Examples

​
2.1 Combine Fields

Combine store [Name] and [Status] with ”-“.

​
2.2 Combine Multi-Select Options

Combine multi-select field [Feedback type (AI tag)] with ”+”.