ARRAYTOTEXT

Returns a cell range or array as one text string, taking the range and an optional format number.

The array or cell range is parsed row by row.

Array: The range or array to return as text.

Format: The format of the returned text, as follows:

• 0 or omitted - concise format (default), returns the values in row order separated by the function separator character (default is comma in US locale) followed by a space.

• 1 - strict format, returns an array constant in braces with text in quotes, column and row separators (default is comma and semicolon in US locale).

Conversion rules:

• 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	Hello World!	#DIV/0!
4		Monday, August 3, 2026

For en-US locale

When Format = 0, the en-US locale uses commas as function separator.

=ARRAYTOTEXT(A1:B4;0) returns the string TRUE, Rio de Janeiro, 123.456, 123.45, Hello World!, #DIV/0!, , 46237.

When Format = 1, the en-US locale uses commas as column separators, and semicolons as row separators.

=ARRAYTOTEXT(A1:B4;1) returns the string array {TRUE,"Rio de Janeiro";123.456,123.45;"Hello World!",#DIV/0!;,46237}.

Other locales

For example, when Format = 0, the pt-BR locale uses semicolons as function separator.

=ARRAYTOTEXT(A1:B4;0) returns VERDADEIRO; Rio de Janeiro; 123,456; 123,45; Hello World!; #DIV/0!; ; 46237

When Format = 1, the pt-BR locale uses dots as column separators, and semicolons as row separators.

=ARRAYTOTEXT(A1:B4;1) returns {VERDADEIRO."Rio de Janeiro";123,456.123,45;"Hello World!".#DIV/0!;.46237}.

COM.MICROSOFT.ARRAYTOTEXT