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

Important

The CONCATENATE() function only supports three arguments. To concatenate more arguments, nest one function inside another.