Skip to content
ExcelExcel 2021+

ARRAYTOTEXT function in Excel

Returns an array of text values from any specified range

=ARRAYTOTEXT(array, [format])

ARRAYTOTEXT syntax and parameters

Two arguments, one required.

  • arrayarrayRequired

    The array to return as text. Required.

  • formatnumberOptional

    The format of the returned data. Optional. It can be one of two values:0 Default. Concise format that is easy to read. The text returned will be the same as the text rendered in a cell that has general formatting applied.1 Strict format that includes escape characters and row delimiters. Generates a string that can be parsed when entered into the formula bar. Encapsulates returned strings in quotes except for Booleans, Numbers and Errors.

ARRAYTOTEXT examples

Formulas you'll actually reuse.

  1. A range as one comma-separated string:

    =ARRAYTOTEXT(A2:A10)

    Result"Berlin, Vienna, Zurich"

  2. Strict format keeps the array shape — semicolons between rows, quotes around text:

    =ARRAYTOTEXT(A2:C4, 1)

ARRAYTOTEXT in Google Sheets

No direct equivalent — here's the way around.

Try ARRAYTOTEXT in the playground

Edit the example — nothing to install.

Preloaded with the ARRAYTOTEXT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.