Text
ARRAYTOTEXT function: turn a cell range into a concise list or array literal
Convert 1D or 2D ranges into comma-separated lists (format 0) or quoted array-constant strings (format 1) with ARRAYTOTEXT.
Concise display vs strict array literal output
ARRAYTOTEXT(array, [format]) serializes a 2D range into text. Format 0 (concise, default) joins values with ", ", while format 1 (strict) wraps the matrix in braces { } with quoted strings, commas between columns, and semicolons between rows.
Use format 1 when building audit trails or exporting a small lookup table as an inline array constant.
=ARRAYTOTEXT(A2:B3, 1)Try the example
Use the original values or change them to test your understanding.