Converts an array of values into a single text string.
Syntax
ARRAYTOTEXT(array, [format])Argument
arrayobligatoriskt
The range or array of values to convert.
formatvalfritt
Optional. Specifies the format: 0 for concise (default) or 1 for strict.
The ARRAYTOTEXT function takes a range or array and returns a text string containing the values separated by commas. It is useful for quickly converting data arrays into a readable format for reports or display purposes.
=ARRAYTOTEXT({1, 2, 3})→1, 2, 3Converts the horizontal array of numbers into a comma-separated string.
Select the cell
Click on the cell where you want the resulting text string to appear.
Enter the formula
Type =ARRAYTOTEXT( followed by the range or array you wish to convert, then close the parenthesis.
Format 0 (concise) does not add quotes to text, while format 1 (strict) adds quotes to text values.