Text
Excel 2021
◉ 29 views
=ARRAYTOTEXT()
Accepts any array and returns the text representations of the array values.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for Mac
=ARRAYTOTEXT(array, [format])
Hover argument names in the table for details.
Output typeText
Popularity10 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =ARRAYTOTEXT() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
array |
Array | Required | The array to return as text. |
format |
Number | Optional | The format of the returned data. Optional. It can be one of two values:0 Default. Concise format that is easy to read. The text returned will be the same as the text rendered in a cell that has general formatting applied.1 Strict format that includes escape characters and row delimiters. Generates a string that can be parsed when entered into the formula bar. Encapsulates returned strings in quotes except for Booleans, Numbers and Errors. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
TRUE |
B2 |
#VALUE! |
A3 |
1234.01234 |
B3 |
Seattle |
A4 |
Hello |
B4 |
$1,123.00 |
A5 |
TRUE |
B5 |
#VALUE! |
A6 |
1234.01234 |
B6 |
Seattle |
A7 |
Hello |
B7 |
$1,123.00 |
TRUE, #VALUE!, 1234.01234, Seattle, Hello, 1,123
=ARRAYTOTEXT(A2:B4,0)
{TRUE,#VALUE!;1234.01234,"Seattle";"Hello","1,123"}
=ARRAYTOTEXT(A2:B4,1)
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!