CONCATENATE Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=CONCATENATE Function |titlemode=append |keywords=planfix, Functions, concatenate, concat |description=CONCATENATE Function }} 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 == Go To == * Standard operators and Planfix functions *Cal...") |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 20: | 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.