CONCATENATE Function
From Planfix
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