Author: Oscar Cronquist Article last updated on October 24, 2022

How to use the ARRAYTOTEXT function

The ARRAYTOTEXT function concatenates values from a given cell range.

1. ARRAYTOTEXT Function Syntax

ARRAYTOTEXT(array, [format])

Back to top

2. ARRAYTOTEXT Function Arguments

array A cell reference or an array.
[format] Optional. This argument lets you change the output format.

0  - Default. Values have a delimiting comma.

1 - Strict format. Both column and row delimiters are used. Encloses all values with quotes except for errors, numbers, and boolean values.

Back to top

3. ARRAYTOTEXT Function examples

How to use the ARRAYTOTEXT function

This example shows the ARRAYTOTEXT function with a 0 (zero) as the second argument.

Formula in cell C3:

=ARRAYTOTEXT(B3:B14,0)

It returns a text string containing values from cell range B3:B14 with a comma and a space character as delimiting characters. Blank empty cells are also included.

How to use the ARRAYTOTEXT function example

This example demonstrates how the ARRAYTOTEXT function returns values in strict form.

Formula in cell C3:

=ARRAYTOTEXT(B3:B14, 1)

The comma is used as a delimiting value between columns and a semicolon is used as a delimiting character between rows. It also encapsulates the result with curly brackets.

Back to top