Concat()

Concatenates two to ten strings or string expressions.

Concat() joins two to ten strings into a single string. At least two string arguments are required, and Concat() can join up to ten strings in a single function call.

Concat() can be nested with other Concat() function calls, meaning you can embed a Concat() function as an argument to the Concat() function.

Syntax

Concat(string1, string2, optional string3, ..., optional string10)

• string1 - string10: strings to join together. Two or more, up to ten, string arguments total.

Example

Concat("Well", "_345") results in "Well_345"

Concat("ABC", Concat("123", "xyz")) results in "ABC123xyz"