Syntax
ARRAYTOTEXT(array, [format])
| Parameter | Description |
|---|---|
| array | Parameter of the ARRAYTOTEXT function. |
| [format] | (Optional.) Parameter of the ARRAYTOTEXT function. |
Examples
Summarize a range
Formula
=ARRAYTOTEXT(A1:C1)
If A1:C1 contains 10, 20, 30, returns "10, 20, 30" as a single text string.
Strict format
Formula
=ARRAYTOTEXT(A1:B2, 1)
Returns something like '{"Apple",10;"Banana",20}' — using strict format with braces, semicolons for rows, and quoted text values.
Debug dynamic array
Formula
=ARRAYTOTEXT(FILTER(A1:A10, B1:B10>50))
Shows the filtered results as a comma-separated text string in a single cell — helpful for quickly inspecting dynamic array output.
Common Errors
#VALUE!
Occurs if the format argument is not 0 (concise) or 1 (strict).
Tips
Concise vs strict
Format 0 (default): comma-separated values. Format 1: braces, semicolons for row breaks, quoted strings — mirrors array constant syntax.
Debugging tool
Wrap any array formula in ARRAYTOTEXT to see all returned values in one cell without spilling. Great for troubleshooting FILTER, SORT, or UNIQUE results.
Complements TEXTSPLIT
ARRAYTOTEXT converts arrays to text. If you need the reverse — text to array — look at TEXTSPLIT (where available).
Try ARRAYTOTEXT in Viztab
Import your data and use ARRAYTOTEXT with 370+ other formulas. No signup required.
Open Viztab