Skip to main content

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".