ARRAYTOTEXT Function in Zoho Sheet: Syntax, Examples and Troubleshooting

• Introduced: Added in March 2023, according to Zoho’s release history; no numbered cloud release is given.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no final supported-version endpoint is identified.
• Scope: The web documentation is the checked reference. Mobile parity and behavior after exchanging files with other applications are not separately established.
• Checked: October 14, 2026, against the official ARRAYTOTEXT page, with independently calculated examples. No native Zoho Sheet test.

=ARRAYTOTEXT(array; [format])

The required array is the cell range to consolidate. The optional format defaults to 0. Zoho describes 0 as a concise, readable representation and 1 as a strict representation that includes escaping. The official examples show semicolons between columns, vertical bars between rows in strict output, and quotes around text values.

The result occupies one cell. ARRAYTOTEXT does not create one output cell for every source value. It also does not offer a custom-delimiter argument; use TEXTJOIN when you need to choose a joining separator instead.

In a blank worksheet, create the following A1:B4 table. Type names as text and scores as numbers. Leave D2:D7 for formulas, so the inputs remain unchanged.

In D6, {"Ada";18|"Ben";25} records two columns and two rows. D4’s concise string reads the same four values row by row but does not preserve the row boundary visibly.

These ordinary text-and-integer cases follow the structure of Zoho’s published examples. They do not establish how every date, percentage, error, empty cell or embedded quotation mark is serialized.

In D9, enter ="Record: "&ARRAYTOTEXT(A2:B2;0). The expected label is Record: Ada; 18. Put the corresponding formula ="Record: "&ARRAYTOTEXT(A3:B3;0) in D10; expect Record: Ben; 25.

This can be useful for displaying the contents of a short record in one cell while retaining the original typed columns for calculations. The label is not a replacement for the underlying table. To total the scores, put =SUM(B2:B4) in B6; expect 74. Do not attempt to add D2:D7, because they are text representations. See SUM for numeric range totals.

If another system needs a machine-readable format, confirm the exact syntax it accepts. ARRAYTOTEXT’s braces and row separators are spreadsheet notation, not a guarantee that the result is valid JSON or CSV. Strict format helps represent the array structure, but this guide does not invent escape rules for embedded quotes that Zoho’s short example table does not demonstrate.

• Format 0: useful for a human-readable summary when preserving the exact two-dimensional layout is unnecessary.
• Format 1: useful for examining an array-shaped representation, where the row/column boundary matters.
• A custom separator: use TEXTJOIN instead of adding an unsupported third argument.
• Numeric analysis: keep the original numbers, or explicitly parse a separately understood numeric-text field. Joining values into a string does not preserve a numeric column for arithmetic.

Zoho’s launch announcement explains the column/row separators and the one-cell output. Neither formatting choice estimates, rounds for a financial policy, or converts between currencies.

The function-specific error table identifies #VALUE! when format is something other than 0 or 1. For example, =ARRAYTOTEXT(A2:B3;2) is outside the documented format choices. It also lists #REF! for an invalid reference and name-related errors for misspellings or malformed formula names.

A cell’s visual formatting and the stored value are different concerns. The help says the source format does not control the conversion, but its short examples do not fully specify every date/percentage/locale output. Preserve source values and check representative records before relying on an exact serialized string. The examples here intentionally avoid embedded delimiters, quotes and unusual Unicode characters.