Back to functions
Text2026-11-110 related articles

ARRAYTOTEXT Function in Excel

Convert an array to readable text or a strict representation that records its rows and columns.

Syntax

ARRAYTOTEXT(array, [format])
Table of Contents

Arguments

array

Required

The array or cell range to represent as text.

format

Optional

Use 0 or omit for concise text; use 1 for strict format. Other values return an error.

What it returns

Returns a text representation of the supplied array in the selected format.

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".

CellValueType
A2NorthText
B212Number
A3TRUELogical
B3BayText

In an empty cell, enter:

=ARRAYTOTEXT(A2:B3)
Formula

With US-style separators, the result is:

North, 12, TRUE, Bay
Example

The 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)
Formula

The strict representation with US separators is:

{"North",12;TRUE,"Bay"}
Example

The 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.

Related functions

Official documentation