ARRAYTOTEXT

Unsupported (not recognized)

Category: Text · Last tested 2026-07-04

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	No	Not yet	n/a
LibreOffice Calc	No	Yes (24.2.7.2, 2026-07-04)	Unsupported (not recognized)

=ARRAYTOTEXT({1,2,3}) on LibreOffice Calc returned #NAME?, but the documented/expected result is 1, 2, 3. MISMATCH vs expected: expected '1, 2, 3', got '#NAME?'
=ARRAYTOTEXT({1,2,3},1) on LibreOffice Calc returned #NAME?, but the documented/expected result is {1,2,3}. MISMATCH vs expected: expected '{1,2,3}', got '#NAME?'
=ARRAYTOTEXT({1,2;3,4}) on LibreOffice Calc returned #NAME?, but the documented/expected result is 1, 2, 3, 4. MISMATCH vs expected: expected '1, 2, 3, 4', got '#NAME?'
=ARRAYTOTEXT({"a","b"},1) on LibreOffice Calc returned #NAME?, but the documented/expected result is {"a","b"}. MISMATCH vs expected: expected '{"a","b"}', got '#NAME?'

Formula	Description	Result	Expected	Verdict
=ARRAYTOTEXT({1,2,3})	Default (concise) format joins elements with comma+space	#NAME?	1, 2, 3	Mismatch
=ARRAYTOTEXT({1,2,3},1)	format=1 (strict) reproduces array-literal syntax with braces	#NAME?	{1,2,3}	Mismatch
=ARRAYTOTEXT({1,2;3,4})	2-D array literal, default format	#NAME?	1, 2, 3, 4	Mismatch
=ARRAYTOTEXT({"a","b"},1)	Strict format quotes text elements	#NAME?	{"a","b"}	Mismatch