ARRAYTOTEXT
Converts array to text representation.
- Excel: Verified match
- Google Sheets: No equivalent
- Returns: Text
Examples
=ARRAYTOTEXT(A1:C3) | A | B | C | |
|---|---|---|---|
| 1 | 10 | 2 | alpha |
| 2 | 20 | 4 | beta |
| 3 | 30 | 6 | gamma |
Result 10, 2, alpha, 20, 4, beta, 30, 6, gamma
Syntax
ARRAYTOTEXT(array, [format])array- range required
format- number optional
Related
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array. CHOOSEROWSReturns the specified rows from an array.