ARRAY

This function creates an array in a cell. The items in the array can be numbers, cell references, boolean values, strings, and other arrays. #ARRAY is displayed in cells that contain arrays.

Functions such as GETKEY return properties of XML variables as strings. Similarly, these functions with the A suffix, return properties of XML variables as arrays:

  • GETKEYSA
  • GETKEYVALUESA
  • GETPROPERTIESA
  • GETPROPERTYVALUESA
  • FINDKEYSA

Syntax

You can create an array of different types of item, such as numbers, boolean values, and strings.

=ARRAY(value {,value}"separator")

Example

=ARRAY(123,789,TRUE,FALSE,"Test","a","b","c",",")

Example

This example references cells that contain arrays:

=ARRAY(C23,C25,C27,C29)

Use, for example, ARRAYTOSTRING to return the values of the referenced arrays as a string.

Related topics