PURGP‖

qxb7y‖ARRAYTOTEXT

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

ebLBc‖Syntax

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

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

GfMDD‖0 or omitted - concise format, returns the values in row order separated by commas (default).
X7usU‖1 - strict format, returns an array constant in braces with text in quotes, comma as column separators and semicolon as row separators.

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

GAZG2‖Examples

nkTbC‖The following table is used as example:

	A	B
1	wEHc5‖TRUE	9uErp‖Rio de Janeiro
2	CMgvr‖123.45600	$1,234.68
3	iG5BE‖Hello World!	qtCLk‖#DIV/0!
4		KT8Vh‖Monday, August 3, 2026

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

DTbq4‖=ARRAYTOTEXT(A1:B4;1) returns the string array {TRUE,"Rio de Janeiro";123.456,1234.678;"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.