CONCAT

Use CONCAT to join two or more text values into one text value.

Use

CONCAT( text1, [text2], ...)
Joins several text items into one text item

Parameter	Required	Description
text1	Yes	The first item to join. The item can be a text value, number, or cell reference.
text2, ...	No	Additional text items to join.

Returns

'Text'

Use with literals

CONCAT("The", " ", "Sun", " ", "is", " ", "Shining")

returns "The Sun is Shining"

Use with fields

CONCAT(@LocateCustomer.out.Forename, " ", @LocateCustomer.out.Surname)

returns "Jane Blogs" where @LocateCustomer.out.Forename is "Jane" and @LocateCustomer.out.Surname is "Blogs"