Excel ARRAYTOTEXT Function Generator

Converts an array or range of values into a single text string

Enter either:
  • Cell range (e.g., A1:C2, D5:F8)
  • Array constant (e.g., 1,2,3;4,5,6)
Use semicolons (;) to separate rows in array constants.

Examples

Scenario Input Result
Cell Range A1:B2 =ARRAYTOTEXT(A1:B2)
Array Constant 1,2;3,4 =ARRAYTOTEXT({1,2;3,4})
Strict Mode 1,2;3,4 with strict mode =ARRAYTOTEXT({1,2;3,4}, 1)