CONCAT

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)
Next item
LOOKUP