Contact
12 programs
Explore the site

ARRAYTOTEXT in Apple Numbers: Concise and Strict Text Output

Text Intermediate Apple Numbers

Convert a Numbers range or array into one text result with ARRAYTOTEXT, including concise and strict modes, structured delimiters and examples.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked

Quick answer: Apple Numbers ARRAYTOTEXT converts a sequence of values into a single text result. Use format 0 (or omit the second argument) for a readable list; use 1 for a strict, structured representation that records column and row boundaries. Apple’s own example with A1:A3 containing 1, 2, 3 produces 1, 2, 3 in concise mode and {1;2;3} in strict mode. These two strings are documented vendor examples, not outputs of a native test performed for this guide. Apple ARRAYTOTEXT, accessed 2026-10-12.

Exact Apple Numbers syntax

=ARRAYTOTEXT(array,format)
Argument Required? Apple-documented type and rule
array Yes Sequence of values; can be a cell range such as A1:A3. Text remains text and nontext values are converted to text.
format No Modal value 0 (concise; default) or 1 (strict). Other values cause an error.

Apple’s strict mode uses curly braces around the output, commas between columns, semicolons between rows, and quotation marks around string values (excluding booleans, numbers and errors). Concise mode follows text displayed in formatted cells. Both modes, in Apple Numbers, return a list of values inside one cell; this guide does not establish a native output-shape difference from Excel. See Apple’s exact ARRAYTOTEXT notes.

Reproducible worksheet 1: three numbers in a column

Create a Numbers table and put these values in column A, with no header row for this exact reference range (or adjust the range if your table has headers):

A1 A2 A3
1 2 3

Enter each of the following formulas in separate unused cells outside the three input cells:

=ARRAYTOTEXT(A1:A3)
=ARRAYTOTEXT(A1:A3,0)
=ARRAYTOTEXT(A1:A3,1)
Formula Apple-documented expected text Meaning
=ARRAYTOTEXT(A1:A3) 1, 2, 3 Concise is the default.
=ARRAYTOTEXT(A1:A3,0) 1, 2, 3 Explicit concise format.
=ARRAYTOTEXT(A1:A3,1) {1;2;3} Three rows separated by semicolons.

Apple publishes the first and third result; the explicit-0 result follows directly from the documented default rule. These values were also independently serialized with a simple string model; no actual Numbers application was run.

Reproducible worksheet 2: why columns and rows differ

Create a 2×2 numeric input region in a separate table, with headers disabled or with the formula range adjusted to exclude the headers:

Cell A1 Cell B1
1 2
3 4

Use:

=ARRAYTOTEXT(A1:B2,1)

Expected strict single-cell string, independently reasoned from Apple’s delimiter rules:

{1,2;3,4}

The comma connects columns within a row and the semicolon starts the next row. This expected result is not an Apple-published exact two-by-two example, and it has not been executed in Numbers. Even though the representation describes two rows and two columns, the ARRAYTOTEXT result is one text string, not four formula-output cells.

Advanced: text labels and structured values

For a 2×2 range containing the values below, use strict mode:

A B
North 5
South 6

Apple says strict mode quotes text values but not numbers. The independently reasoned text representation is:

{"North",5;"South",6}

If imported strings themselves contain embedded quotes, newlines or delimiters, Apple’s help establishes the presence of escape characters in strict mode, but does not enumerate every precise escape transformation in the inspected text. Do not treat the above as a complete CSV/JSON serializer and do not claim specific escape sequences without a native test.

Choose the format based on the consumer

  • Concise (0): a human-readable single-cell summary. Formatting influences how text appears; a date or currency value may become locale-dependent text.
  • Strict (1): a structured single-cell rendering of an array, with braces and documented row/column separators. Useful for inspecting rectangular arrays, not a replacement for a supported interchange file format.

Invalid format

=ARRAYTOTEXT(A1:A3,2)

Apple explicitly documents that any format other than 0 or 1 causes an error. The exact error message/code in Numbers was not recorded in this research and is not invented here.

Troubleshooting and limits

Symptom / question Evidence-based answer
Default output is not braced Default is concise (0); use 1 for strict serialization.
Strict result contains ; and , Apple’s strict syntax uses semicolons for rows and commas for columns; these data delimiters are different from the locale’s formula-argument separator.
Numbers shows one cell instead of a spilled array Correct according to Apple’s reference: both modes return one cell.
Format 2 raises an error Apple explicitly permits only 0 or 1; exact displayed error text remains untested.
Text is quoted unexpectedly Strict format quotes text values, not ordinary numeric/Boolean values.
Currency/date rendering varies Concise mode uses displayed formatted text, which can change with number format and locale; do not hard-code a cross-locale expected string.
Only a partial range appears Check that you supplied the intended A1:B2 boundaries and not a truncated selection.
Comparing Excel ARRAYTOTEXT output Compare the actual serialized text in each app; the wording of their references alone does not establish a spill-shape difference.

Compatibility: Apple Numbers versus Excel

The signature names align: Apple and Microsoft Excel both document ARRAYTOTEXT(array,[format]) and 0/1 modes. Microsoft’s page describes strict output both as a parseable string and, in a note, as an array matching the input shape; its published example shows a braced serialization. That wording does not establish that Excel spills cells while Numbers does not. Apple’s page explicitly says both modes return one cell. Compare the resulting text in the applications before making a portability assumption. Microsoft names Excel’s #VALUE! for invalid format; Apple says only error. Neither app was executed for this guide.

Locale, table references and version scope

In an English-formatted Numbers document use a comma between function arguments, e.g. =ARRAYTOTEXT(A1:B2,1). If your regional decimal separator is a comma, Apple’s overview tells you to type a semicolon between arguments: =ARRAYTOTEXT(A1:B2;1). In either case, strict-format output text still uses Apple’s documented , between columns and ; between rows.

Apple Numbers uses tables. Same-table A1:B2 is a local reference; another table may require Table 2::A1:B2, and another sheet may require sheet and table qualifiers, per Apple’s cell-reference rules. Verify the actual reference created in the formula editor, especially in tables with header names.

The source is Apple’s Formulas and Functions Help 15.4 (checked 2026-10-12), not evidence of the first Mac/iPad/iPhone/iCloud app version supporting ARRAYTOTEXT. Apple’s Mac release notes discuss array spilling in Numbers 14.4, but ARRAYTOTEXT in Numbers returns one cell in either format according to its own reference. Check availability in the installed app’s Function Browser; don’t equate documentation edition with minimum supported OS or device version.

Apple lists TEXTSPLIT as related; it has the opposite conceptual direction, turning delimiter-separated text into multiple output values. Apple’s full function catalogue also identifies TEXTJOIN and CONCAT. The official links cited in this paragraph, Apple’s ARRAYTOTEXT page, and Microsoft’s ARRAYTOTEXT reference were checked 2026-10-12.

Verification status: Official documentation reviewed; two vendor examples directly checked and additional outputs independently reasoned from the documented serialization rules. Not executed in Apple Numbers. No native Numbers screenshots or execution were performed.