ARRAYTOTEXT Function

Description

Convert an array or reference range to a text string.

NOTE

• For number data types, the result obtained include only raw values.
• The resulting format may be affected by the system/list separator settings from Excel.

Syntax

Copied!=ARRAYTOTEXT(array,[format])
=ARRAYTOTEXT(array,[format])

EXAMPLE

Copied![𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭] 𝘧𝘰𝘳𝘮𝘢𝘵=[0,1] - 𝘧𝘪𝘳𝘴𝘵 𝘷𝘢𝘭𝘶𝘦 𝘪𝘴 𝘥𝘦𝘧𝘢𝘶𝘭𝘵

//𝘧𝘰𝘳𝘮𝘢𝘵=0, 𝘤𝘰𝘯𝘤𝘢𝘵𝘦𝘯𝘢𝘵𝘪𝘰𝘯 = 𝘤𝘦𝘭𝘭 𝘣𝘺 𝘤𝘦𝘭𝘭.
=ARRAYTOTEXT(A1:B3)
//𝘧𝘰𝘳𝘮𝘢𝘵=1, 𝘤𝘰𝘯𝘤𝘢𝘵𝘦𝘯𝘢𝘵𝘪𝘰𝘯 = 𝘤𝘦𝘭𝘭 𝘣𝘺 𝘤𝘦𝘭𝘭 + 𝘳𝘰𝘸 𝘣𝘺 𝘳𝘰𝘸.
=ARRAYTOTEXT(A1:B3, 1)
[𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭] 𝘧𝘰𝘳𝘮𝘢𝘵=[0,1] - 𝘧𝘪𝘳𝘴𝘵 𝘷𝘢𝘭𝘶𝘦 𝘪𝘴 𝘥𝘦𝘧𝘢𝘶𝘭𝘵

//𝘧𝘰𝘳𝘮𝘢𝘵=0, 𝘤𝘰𝘯𝘤𝘢𝘵𝘦𝘯𝘢𝘵𝘪𝘰𝘯 = 𝘤𝘦𝘭𝘭 𝘣𝘺 𝘤𝘦𝘭𝘭.
=ARRAYTOTEXT(A1:B3)
//𝘧𝘰𝘳𝘮𝘢𝘵=1, 𝘤𝘰𝘯𝘤𝘢𝘵𝘦𝘯𝘢𝘵𝘪𝘰𝘯 = 𝘤𝘦𝘭𝘭 𝘣𝘺 𝘤𝘦𝘭𝘭 + 𝘳𝘰𝘸 𝘣𝘺 𝘳𝘰𝘸.
=ARRAYTOTEXT(A1:B3, 1)

RELATED