ARRAYTOSTRING

Returns a single string that contains all the items in an array.

See ARRAY.

The items are separated by a separator that you specify, not by the separator specified in the ARRAY function.

Syntax

=ARRAYTOSTRING(array,"separator")

Example

Cell C8 contains =ARRAY(123,456,TRUE,FALSE,"Test","a","b","c",","). =ARRAYTOSTRING(C8,"-x-") returns this result:

123-x-456-x-TRUE-x-FALSE-x-Test-x-a-x-b-x-c

Related topics