Combines the given range of values into a single array of text values irrespective of the source format.
Syntax
ARRAYTOTEXT(array; [format])
array: The cell range containing the values to consolidate. Eg., A2:A5
format: The format in which the result must be. Defaults to 0 if omitted.
0 - Concise format that is easy to read.
1 - Strict format with escape characters included.
Examples
Formula | Result |
=ARRAYTOTEXT(A2:A5) | John; Priya; Ming; Mary |
=ARRAYTOTEXT(A2:B3) | John; 23; Priya; 25 |
=ARRAYTOTEXT(A2:B3;1) | {"John";23|"Priya";25} |
Get a hands-on experience of the function in the embedded range below.
Possible Errors
Errors | Meaning |
#NAME! | The function name is incorrect or invalid. The given defined name (if any) is invalid. There is a typo in the defined name used in the function. Double quotes are missing for text values in the function. Colon missing in a cell range reference.
|
#VALUE! | |
#REF! | |
Similar Functions