ARRAYTOTEXT

This function converts an array to a text string.

Syntax

ARRAYTOTEXT(array, [format])

Arguments

Return Value

Returns a text representation of the specified array.

Remarks

• If omitted, format defaults to 0.

• Each element in the array is converted using the same rules as VALUETOTEXT.

• Output is based on General format, regardless of cell formatting.

• In concise mode (0):

  • Values are returned as a comma-separated list.

  • The group separator follows the current culture settings.

• In strict mode (1):

  • The result is enclosed in braces {}.

  • Columns are separated by commas.

  • Rows are separated by semicolons.

  • Text values are quoted and escaped.

• Localized text depends on the current culture settings.

Examples

Given the range A1:B3:

Concise mode

=ARRAYTOTEXT(A1:B3,0)

Result:

TRUE, #VALUE!, 1234.01234, Seattle, Hello, 1123

Strict mode

=ARRAYTOTEXT(A1:B3,1)

Result:

'{TRUE,#VALUE!;1234.01234,"Seattle";"Hello",1123}'

See Also

• VALUETOTEXT

• TEXT

• T

• VALUE