What ARRAYTOTEXT does
ARRAYTOTEXT represents the values in an array as text. Concise format makes the values easy to read. Strict format includes quotation marks and separators that describe the array's structure.
It is useful when you want to inspect an array's values and arrangement. For a list with your own delimiter, use TEXTJOIN. For one value, see VALUETOTEXT.
Practical examples
Read a small range as text
Enter these values in A2:B3. Use a real number in B2 and a logical TRUE in A3, not the text "TRUE".
| Cell | Value | Type |
|---|---|---|
| A2 | North | Text |
| B2 | 12 | Number |
| A3 | TRUE | Logical |
| B3 | Bay | Text |
In an empty cell, enter:
=ARRAYTOTEXT(A2:B3)FormulaWith US-style separators, the result is:
North, 12, TRUE, BayExampleThe values appear in row order in one text cell. The omitted format argument uses 0, so the result favors readability without marking the boundary between the two source rows. Both examples were verified in Excel for Mac 16.114 (build 16.114.26101123) on November 11, 2026.
Keep the row and column structure in the text
With the same A2:B3, enter:
=ARRAYTOTEXT(A2:B3,1)FormulaThe strict representation with US separators is:
{"North",12;TRUE,"Bay"}ExampleThe comma separates columns and the semicolon separates rows. North and Bay have quotation marks because they are text; 12 and TRUE don't. The braces mark the array representation. This is Excel array-style text, not a CSV or JSON export format.
The result occupies one cell; it doesn't spill into a two-by-two range. In the native test, ISTEXT returned TRUE and ROWS and COLUMNS each returned 1 for the strict result. The punctuation preserves the source layout within the text, rather than creating four output cells.
Common mistakes and notes
Strict punctuation has a purpose
Don't remove quotes or replace separators casually if you need to retain the distinction between text, numbers, and row boundaries. These examples use US separators; account for your Excel locale when comparing the output.
Choose a supported format value
The format argument accepts 0 for concise output and 1 for strict output. For example, =ARRAYTOTEXT(A2:B3,2) returns #VALUE!. Microsoft's ARRAYTOTEXT documentation describes the two formats and the invalid-format error.
Display formatting is a separate choice
Don't assume that a source cell's currency or date display will be preserved in the text representation. If the display matters, format the values deliberately before joining them into a report label.