Formualizer Docs
ReferenceFunctionsText Functions

ARRAYTOTEXT

ARRAYTOTEXT: Converts an array or range into a text representation.

Summary

ARRAYTOTEXT(array, [format]) supports concise (0) and strict (1) output styles.

Remarks

  • Strict mode returns brace-delimited array syntax with row/column separators.
  • Concise mode flattens all values into a comma-space list.
  • Cells are converted using the same scalar text rules used by VALUETOTEXT.
  • Errors in scalar-only input propagate immediately.

Examples

Concise flattened output
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1, 2, 3
Strict 2D representation
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
{1,2;3,4}

FAQ

What changes when format is 1?

Format 1 returns brace-delimited array syntax; format 0 flattens values into a comma-space list.

Runtime metadata

Category

Text

Signature

ARRAYTOTEXT(arg1: Any | Range (Range), arg2?: Number)

Arity

min 1, max 2

Arguments

arg1

Any | Range · Range

arg2optionaldefault

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/array_text.rs

Text Functions

Generated reference pages for Text functions.

CHAR

Returns the character specified by a number Excel uses Windows-1252 encoding for codes 1-255.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat changes when format is 1?Runtime metadata