ARRAYTOTEXT

ARRAYTOTEXT(array [,format])

Returns the contents of an array or cell range converted to text.

array	The cell range or array to convert to a text string.
format	(Optional) The format: 0 = easy to read format, concise (default) 1 = array format with curly brackets, strict

REMARKS

* This function was added in Excel 2024.
* This function can create a Dynamic Array Formula.
* If "format" = 0 then the text returned will be the same as the text rendered in a cell that has general formatting applied.
* If "format" = 1 then everything is placed inside double quotes except for Booleans, Numbers and Errors.
* Values are separated by either commas (,) or semicolons (;), depending on the format requested and the structure of the array.
* Rows are separated by semicolons and columns are separated by commas.
* This function will always remove number formatting applied to any cells containing numeric values.
* If you have a list of Linked Data Types this function should be used because the TEXTJOIN function will not work.
* You can use the TEXT function to return the number as a formatted text string.
* You can use the TEXTJOIN function to return the text string that is a concatenation of several strings with a delimiter.
* You can use the VALUETOTEXT function to convert any value into text.
* This function was first released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=ARRAYTOTEXT(B1:B3) = Mon, Tue, Wed	Mon
2	=ARRAYTOTEXT(B1:B3, 0) = Mon, Tue, Wed	Tue
3	=ARRAYTOTEXT(B1:B3, 1) = {"Mon";"Tue";"Wed"}	Wed
4	=ARRAYTOTEXT(B1:B5, 0) = Mon, Tue, Wed, 100,	100
5	=ARRAYTOTEXT(B1:B5, 1) = {"Mon";"Tue";"Wed";100;}
6	=ARRAYTOTEXT("some text") = some text

1 - What is the text representation of the contents of cells "B1:B3".
2 - What is the text representation of the contents of cells "B1:B3" with the concise format.
3 - What is the text representation of the contents of cells "B1:B3" with the strict format.
4 - What is the text representation of the contents of cells "B1:B5" (text, numbers and blank) with the concise format.
5 - What is the text representation of the contents of cells "B1:B5" (text, numbers and blank) with the strict format.
6 - What is the text representation of a text string.