Concatenates strings of text. You can include as many values as necessary.

The Concat() function has two parameters:

  • string1 (string): Required. A string of text.
  • string2 (string): Required. A string of text to add to the end of string1.

You can concatenate as many values as you want adding additional values to the end of the list of parameters.

To use this function, pass it at least two strings. The strings are appended to each other in order. This function concatenates a first, middle, and last name to form a full name. To include spaces between strings, you must explicitly include space characters in the function.

The function outputs the full name.