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"