Welcome to Portal

?Unknown\pull-down

Welcome to Zoho Cares

Bienvenido a Soporte de Zoho

Search our knowledge base, ask the community or submit a request.

ARRAYTOTEXT

Combines the given range of values into a single array of text values irrespective of the source format.
 
Syntax
 
ARRAYTOTEXT(array; [format])
array: The cell range containing the values to consolidate. Eg., A2:A5
format: The format in which the result must be. Defaults to 0 if omitted.
0 - Concise format that is easy to read.
1 - Strict format with escape characters included.
 
Examples
 
Formula
Result
=ARRAYTOTEXT(A2:A5)
John; Priya; Ming; Mary
=ARRAYTOTEXT(A2:B3)
John; 23; Priya; 25
=ARRAYTOTEXT(A2:B3;1)
{"John";23|"Priya";25}

Get a hands-on experience of the function in the embedded range below.

 

Possible Errors
 
Errors
Meaning
#NAME!
  • The function name is incorrect or invalid.
  • The given defined name (if any) is invalid.
  • There is a typo in the defined name used in the function.
  • Double quotes are missing for text values in the function.
  • Colon missing in a cell range reference.
#VALUE!
  • The given argument's data type is incorrect or invalid.
  • The format parameter is a value other than 0 or 1.
#REF!
  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.
 
Similar Functions
  • CONCATENATE
  • TEXTJOIN

Helpful?00
Updated: 2 years ago
Share :