Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the CONCAT function.
Description
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter arguments.
Syntax
CONCAT(text1, [text2],…)
The CONCAT function syntax has the following arguments:
- text1 - Required. Text item to be joined. A string, or array of strings, such as a range of cells.
- [text2, ...] - Optional: Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.
Examples
| Formula | Description | Result |
| =CONCAT({variable}, " is required") | Creates a sentence using a variable (assuming its value is Field) and text | Field is required |
| =CONCAT("This ", "is ", "a ", "sentence.") | Creates a sentence using multiple text arguments. | This is a sentence |
Errors
For a full list of formula errors, please read Formula errors.