ARRAYTOTEXT function
Summary
Returns an array of text values from any specified range
Syntax
ARRAYTOTEXT(array, [format])
The ARRAYTOTEXT function syntax has the following arguments.
array The array to return as text. Required.
format The format of the returned data. Optional. It can be one of two values:
0 Default. Concise format that is easy to read. The text returned will be the same as the text rendered in a cell that has general formatting applied.
1 Strict format that includes escape characters and row delimiters. Generates a string that can be parsed when entered into the formula bar. Encapsulates returned strings in quotes except for Booleans, Numbers and Errors.
array The array to return as text. Required.
format The format of the returned data. Optional. It can be one of two values:
0 Default. Concise format that is easy to read. The text returned will be the same as the text rendered in a cell that has general formatting applied.
1 Strict format that includes escape characters and row delimiters. Generates a string that can be parsed when entered into the formula bar. Encapsulates returned strings in quotes except for Booleans, Numbers and Errors.
Example
=ARRAYTOTEXT(A2:B4,0)
=ARRAYTOTEXT(A2:B4,1)
=ARRAYTOTEXT(A2:B4,1)