ARRAYTOTEXT
Returns an array of text values from any specified range.
TextModern Excel FunctionsText Processing
What it does
Converts an array or range of cells into a single text string.
Syntax
ARRAYTOTEXT(array, [format])
Arguments
array(array) — The range or array to convert.format(number) — 0 for concise (comma-separated), 1 for strict (JSON-like format).
Examples
Convert range to text
Convert a list of names to a single string.
FORMULA
=ARRAYTOTEXT(A2:A4, 0)
RESULT
Alice, Bob, Charlie
SAMPLE DATA
| A | |
|---|---|
| 1 | Names |
| 2 | Alice |
| 3 | Bob |
| 4 | Charlie |