ARRAYTOTEXT
Returns an array of text values from any specified range
Syntax
ARRAYTOTEXT(array, [format])
Parameters
- array: Required. The array to return as text
- format: Optional. 0=concise format (default), 1=strict format with escape characters and row delimiters
Example
=ARRAYTOTEXT(A1:B2, 1)