Quick Navigation
ARRAYTOTEXT Function
Summary
The ARRAYTOTEXT function converts arrays, ranges, or individual values into a text representation. It transforms Excel data into readable text strings, making it perfect for displaying array results in single cells or creating parseable text outputs for formulas.
Syntax
ARRAYTOTEXT(array, [format])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| array | Array/Range |
Yes | Required input array or range to convert to text format |
| format | Number |
No | Optional. 0=concise readable format, 1=strict format with delimiters |
Using the ARRAYTOTEXT Function
ARRAYTOTEXT is essential when working with dynamic arrays in modern Excel. Use it to display spill array results as single-cell text, create formula-friendly string representations, or prepare data for text-based processing while maintaining the original data's visual formatting.
Common ARRAYTOTEXT Examples
Concise Format Display
=ARRAYTOTEXT(A1:B3,0)Converts a 2x3 range into comma-separated text: "TRUE, #VALUE!, 1234.01, Seattle, Hello, 1,123"
Strict Array Format
=ARRAYTOTEXT(A1:B3,1)Returns parseable array string: "{TRUE,#VALUE!;1234.01,\"Seattle\";\"Hello\",\"1,123\"}"
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Format parameter is not 0 or 1
Solution: Use only 0 (concise) or 1 (strict) for the format argument
Unexpected text formatting
Cause: Input contains complex formatting
Solution: ARRAYTOTEXT uses general format rendering
Notes
- Available only in Excel 365 and Excel 2021
- Concise format (0) collapses multi-cell arrays into single-cell text
- Strict format (1) preserves array dimensions with { } notation and semicolons
- Text values are quoted in strict format except for numbers, booleans, and errors
Compatibility
Available in: Excel 365, Excel 2021
Not available in: Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 365, Excel 2021