PURGP‖

qxb7y‖ARRAYTOTEXT

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

ByCFd‖Array: The range or array to return as text.

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

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

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

• nZv5R‖A number retains its input text while ignoring cell formatting.

• GvijW‖A boolean displays as TRUE or FALSE in the current locale.

• bFU6r‖An empty cell contributes nothing.

• 52Bj2‖In a range, an error is listed as its error text, whereas a reference to a single error cell returns that error.

• 84A5d‖Date values return the internal date number.

nkTbC‖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

BaM5W‖For en-US locale

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

HW2uV‖The en-US locale uses commas as column separators, and semicolons as row separators.

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

nnEDX‖Other locales

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

aPpU7‖For example, the pt-BR locale uses dots as column separators, and semicolons as row separators.

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

COM.MICROSOFT.ARRAYTOTEXT