> ## 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.

# Text concatenation functions

> Concatenate text in DingTalk Spreadsheet with the & operator, CONCAT, and TEXTJOIN.

| Tag | Concatenation, &,<br />CONCAT, TEXTJOIN |
| --- | --------------------------------------- |

In DingTalk Spreadsheet, you can concatenate text using several methods.

## Method 1: The "&" concatenation operator

Place the `&` operator between values to join them, for example `=A2 & B2 & C2`.

## Method 2: CONCATENATE and CONCAT functions

The CONCATENATE function joins multiple text strings together, with each argument representing one text string.

CONCAT is a more flexible text concatenation function. Each argument can be a single text string or a reference that points to multiple text strings.

## Method 3: TEXTJOIN function

The TEXTJOIN function also joins multiple text strings, inserting a specified delimiter between each pair of strings.

The arguments of the TEXTJOIN function are, in order:

* **Delimiter (required). If left empty, the result is the same as the CONCATENATE function.**

* **Whether to ignore empty text.**

* **One or more arguments specifying the text to join. At least one is required.**

***