> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.
# Using TEXTJOIN
> 📌 More functions: see the formula function reference.
> 📌 More functions: see the [Formula function reference](/aitable/formulas/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
```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
TEXTJOIN([delimiter], [ignore_empty], [text1], [text2])
```
**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
```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
TEXTJOIN(", ", TRUE(), [Field 1], [Field 2], [Field 3], [Field 4])
```
Result: **Apple, Banana, Grape**
#### Example 2: keep empty
```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
TEXTJOIN(", ", FALSE(), [Field 1], [Field 2], [Field 3], [Field 4])
```
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 "-".
```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
TEXTJOIN("-",TRUE(),[Name],[Status])
```
### 2.2 Combine multi-select options
Combine multi-select field \[Feedback type (AI tag)] with "+".
```dax theme={"theme":{"light":"github-light","dark":"github-dark"}}
TEXTJOIN("+",TRUE(),[Feedback type (AI tag)])
```