CONCATENATE Function: Difference between revisions
From Planfix
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 6: | Line 6: | ||
}} | }} | ||
The function concatenates arguments into a string. | The function concatenates arguments into a string. | ||
Format: | Format: | ||
| Line 15: | Line 14: | ||
'''CONCAT()''' | '''CONCAT()''' | ||
Examples: | Examples: | ||
| Line 22: | Line 20: | ||
CONCATENATE("1";"+";"4") = 1+4 | CONCATENATE("1";"+";"4") = 1+4 | ||
==Important== | |||
*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.