Description
The CONCAT function concatenates or combines two or more text values together.
Usage
CONCAT(text1, text2, ...)
Remarks
Each of the arguments must have a text type, or be convertable to text with TEXT function.
Any blank arguments are ignored.
Examples
Combine first and last name
If you have a form with a seperate text field for FIRST_NAME and LAST_NAME, you can combine them using the formula:
CONCAT(FIRST_NAME, " ", LAST_NAME)