Courses
CONCAT Function
Return value
Returns joined items as one text.
Syntax
= CONCAT(text1; ...)
Arguments
| Argument | Description |
|---|---|
| text1 | The first item to join: Text, Number or Reference. |
| [text…n] | [Optional]: Up to the limit of 255 items and a total of 8 192 characters. |
Remarks
Tip: Using the “&” Operator to join items
Instead of CONCAT, the “&” operator can be used to join items. “&” works the same way as CONCAT, but is not limited to 255 items. We recommend the “&” operator as it is not limited and also results in cleaner formulas.