# ARRAYTOTEXT

## Content

This function converts an array to a text string.

## Syntax

```auto
ARRAYTOTEXT(array, [format])
```

## Arguments

| Argument | Description |
| -------- | ----------- |
| array | The array or range to convert. |
| format | Optional. Specifies the output format.<ul><li>`0` — Concise format (default).</li><li>`1` — Strict format.</li></ul> |

## Return Value

Returns a text representation of the specified array.

## Remarks

* If omitted, format defaults to `0`.
* Each element in the array is converted using the same rules as VALUETOTEXT.
* Output is based on General format, regardless of cell formatting.
* In concise mode (`0`):
    * Values are returned as a comma-separated list.
    * The group separator follows the current culture settings.
* In strict mode (`1`):
    * The result is enclosed in braces `{}`.
    * Columns are separated by commas.
    * Rows are separated by semicolons.
    * Text values are quoted and escaped.
* Localized text depends on the current culture settings.

## Examples

Given the range A1:B3:

| TRUE | #VALUE! |
| ---- | ------- |
| 1234.01234 | Seattle |
| Hello | $1,123.00 |

### Concise mode

```auto
=ARRAYTOTEXT(A1:B3,0)
```

Result:

```auto
TRUE, #VALUE!, 1234.01234, Seattle, Hello, 1123
```

### Strict mode

```auto
=ARRAYTOTEXT(A1:B3,1)
```

Result:

```auto
'{TRUE,#VALUE!;1234.01234,"Seattle";"Hello",1123}'
```

## See Also

* [VALUETOTEXT](/spreadjs/docs/formulareference/FormulaFunctions/text-functions/valuetotext)
* [TEXT](/spreadjs/docs/formulareference/FormulaFunctions/text-functions/TEXT)
* [T](/spreadjs/docs/formulareference/FormulaFunctions/text-functions/T)
* [VALUE](/spreadjs/docs/formulareference/FormulaFunctions/text-functions/VALUE)