CONCATENATE
Returns a single string that is the result of concatenating two or more string values. Is the same as CONCAT
Syntax
string CONCATENATE(params string[] values)
Example
You can join two or more columns into a single string by entering the column name for each. Each column needs to be separated by a comma in the function.
Unless specified the values will have no separator (e.g. a space, dash, semi-colon, comma etc.)
CONCATENATE(Value1, Value2)
or
CONCATENATE("Telephone", "-", "0044 1424 863 450")
Will return "Telephone - 0044 1424 863 450".
or
Customer full name from the Customer Database, using CustFirstname = John and CustSurname = Smith separated by a space.
CONCATENATE("CustFirstname", " ", "CustSurname")
Will return "John Smith".