PURGP‖

qxb7y‖ARRAYTOTEXT

zbnqB‖Returns a cell range or array as one text string, taking the range and an optional format number.

MBG7V‖The array or cell range is parsed row by row.

ebLBc‖Syntax

ByCFd‖Array: The range or array to return as text.

mvorz‖Format: The format of the returned text, as follows:

VMCmA‖0 or omitted - concise format (default), returns the values in row order separated by the function separator character (default is comma in US locale) followed by a space.
LDCLF‖1 - strict format, returns an array constant in braces with text in quotes, column and row separators (default is comma and semicolon in US locale).

xTc6b‖In LibreOfficeDev Calc, separators are locale-dependent and can be configured under Tools > Options > LibreOfficeDev Calc > Formula > Separators.

C34Xs‖Conversion rules:

nZv5R‖A number retains its input text while ignoring cell formatting.
GvijW‖A boolean displays as TRUE or FALSE in the current locale.
bFU6r‖An empty cell contributes nothing.
52Bj2‖In a range, an error is listed as its error text, whereas a reference to a single error cell returns that error.
84A5d‖Date values return the internal date number.

GAZG2‖Examples

nkTbC‖The following table is used as example:

	A	B
1	TRUE	Rio de Janeiro
2	123.45600	$1,234.68
3	Hello World!	#DIV/0!
4		Monday, August 3, 2026

BaM5W‖For en-US locale

D2ekq‖When Format = 0, the en-US locale uses commas as function separator.

yJFjY‖=ARRAYTOTEXT(A1:B4;0) returns the string TRUE, Rio de Janeiro, 123.456, 123.45, Hello World!, #DIV/0!, , 46237.

bh8Js‖When Format = 1, the en-US locale uses commas as column separators, and semicolons as row separators.

SNCiW‖=ARRAYTOTEXT(A1:B4;1) returns the string array {TRUE,"Rio de Janeiro";123.456,123.45;"Hello World!",#DIV/0!;,46237}.

nnEDX‖Other locales

sUYzM‖For example, when Format = 0, the pt-BR locale uses semicolons as function separator.

U6v2t‖=ARRAYTOTEXT(A1:B4;0) returns VERDADEIRO; Rio de Janeiro; 123,456; 123,45; Hello World!; #DIV/0!; ; 46237

yhN3i‖When Format = 1, the pt-BR locale uses dots as column separators, and semicolons as row separators.

5KbBB‖=ARRAYTOTEXT(A1:B4;1) returns {VERDADEIRO."Rio de Janeiro";123,456.123,45;"Hello World!".#DIV/0!;.46237}.

XAFa7‖Technical information

wB7Kb‖This function is available since LibreOfficeDev 27.2.

Gewrf‖This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.4. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.ARRAYTOTEXT

n44o5‖ARRAYTOTEXT wiki page.