CONCAT

Combines multiple inputs into one text value in the order provided.

Function syntax

CONCAT(input1, input2, ...)

Arguments:

• input1, input2, …: One or more values, cells, or data fields to concatenate.

Examples

• CONCAT(“Hello”, ” ”, “World”) - Combines text values into Hello World.
• CONCAT(A2, ”-”, B2) - Combines the values in A2 and B2 with a hyphen between them.
• CONCAT(“address”, A5, zip{!-1}) - Combines address, the value in A5, and the last value in the zip field.