Concatenates the specified strings into one string, without a separator.
If an array is passed as a parameter, that array is converted to a string first and then concatenated. Parameters that don't hold a text data type are converted to string before being operated on.
concat( {text, …} )
text: (Text Array) One of the strings or a set of strings that will be concatenated.
Text
If an array is passed as a parameter, that array is converted to a string first and then concatenated. Parameters that don't hold a text data type are converted to string before being operated on.
concat({"a","b","c"},{"d","e","f"})
returns abcdef