Returns a cell range or array as one text string, taking the range and an optional format number.
Array: The range or array to return as text.
Format: The format of the returned text, as follows:
0 or omitted - concise format, returns the values in row order separated by commas (default).
1 - strict format, returns an array constant in braces with text in quotes, comma as column separators and semicolon as row separators.
A number retains its input text while ignoring cell formatting. A boolean displays as TRUE or FALSE in the current locale. An empty cell contributes nothing. In a range, an error is listed as its error text, whereas a reference to a single error cell returns that error. Date values return the internal date number.
The following table is used as example:
|
A |
B |
|
|---|---|---|
|
1 |
TRUE |
Rio de Janeiro |
|
2 |
123.45600 |
$1,234.68 |
|
3 |
¡Hola, mundu! |
#¡DIV/0! |
|
4 |
Monday, August 3, 2026 |
=ARRAYTOTEXT(A1:B4;0) returns the string TRUE, Rio de Janeiro, 123.456, 1234.678, Hello World!, #DIV/0!, , 46237.
=ARRAYTOTEXT(A1:B4;1) returns the string array {TRUE,"Rio de Janeiro";123.456,1234.678;"Hello World!",#DIV/0!;,46237}.
COM.MICROSOFT.ARRAYTOTEXT
