ARRAYTOTEXT

ARRAYTOTEXT(array [,format])

Returns the contents of an array or cell ranges converted into text.

arrayThe 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 Microsoft 365.
* 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 released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com

 AB
1=ARRAYTOTEXT(B1:B3) = Mon, Tue, WedMon
2=ARRAYTOTEXT(B1:B3, 0) = Mon, Tue, WedTue
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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top