concat() Function

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.

Syntax

concat( {text, …} )

text: (Text Array) One of the strings or a set of strings that will be concatenated.

Returns

Text

Notes

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.

Examples

You can experiment with this function in the test box below.

Test Input

concat({"a","b","c"},{"d","e","f"}) returns abcdef

FEEDBACK