CONCATENATE Function

From Planfix
Revision as of 14:03, 5 December 2024 by Dmitri (talk | contribs) (→‎Important)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.

Go To