CONCATENATE Function: Difference between revisions
From Planfix
No edit summary |
|||
| Line 21: | Line 21: | ||
CONCATENATE("1";"+";"4") = 1+4 | CONCATENATE("1";"+";"4") = 1+4 | ||
==Important== | ==Important== | ||
The CONCATENATE() function only supports three arguments. To concatenate more arguments, nest one function inside another. | *The CONCATENATE() function only supports three arguments. To concatenate more arguments, nest one function inside another. | ||
== Go To == | == Go To == | ||
Latest revision as of 14:03, 5 December 2024
The function concatenates arguments into a string.
Format:
CONCATENATE("Text_1";"Delimiter";"Text_2")
CONCATENATE()
CONCAT()
Examples:
CONCATENATE("Lewis";" ";"Nelson") = Lewis Nelson
CONCATENATE("1";"+";"4") = 1+4
Important
- The CONCATENATE() function only supports three arguments. To concatenate more arguments, nest one function inside another.