Wauvel

Excel like a finance pro.

← The library

Text function

ARRAYTOTEXT

Returns an array as a single text string.

Rarely usedDifficulty 1250 · ProficientUsage rank #274 of 520
Practice · 2 questions →

When to use it

Turns an array or range into a single text. Concise format lists values with commas; strict format shows braces and quotes like an array constant.

The shape of it

Syntax
=ARRAYTOTEXT(array, [format])

Worked examples

  • Concise

    =ARRAYTOTEXT(A2:B3) → Widget, 10, Gadget, 25

    Concise, row by row.

  • Strict

    =ARRAYTOTEXT(A2:B3,1) → {"Widget",10;"Gadget",25}

    Strict format, which can be pasted back as an array constant.

  • Show a spill in one cell

    =ARRAYTOTEXT(FILTER(A2:A6,C2:C6="West")) → Widget, Gizmo

    A quick readout of a dynamic array.

Worth knowing

  • Handy for logging what an array formula produced.
  • TEXTJOIN gives control over the separator.
  • Strict mode escapes quotes inside text.

Where it goes wrong

  • Errors in the array appear as their text (#N/A).
  • Requires Excel 2021 or Microsoft 365.

Related

LEFTRIGHTLENTRIMUPPERLOWER

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.