Skip to main content
TagConcatenation, &,
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.
Back to Spreadsheet