CONCATALL

The CONCATALL function joins all items in a list into a single text string by using the specified delimiter. This function is commonly used to combine multiple text values with separators such as spaces, commas, or symbols.

Syntax

CONCATALL([string1, string2, ..., stringn], delimiter)

Arguments

• [string1, string2, ..., stringn]: The list of text values to join. Numeric values in the list are also converted to text and concatenated.
• delimiter: The text separator inserted between each value.

Return value

Returns a single text string that combines all items in the list using the specified delimiter.

Example

CONCATALL(["Product1", "Product2"], "--")

Returns Product1--Product2.