ARRAY

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. Use these functions to work with arrays:

  • ArrayLength: Returns the number of items in an array.
  • ArrayToString: Returns all the items in an array as a string.
  • GetArrayItem: Returns a single item from an array.

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(item, item, "string", "string separated by a separator", item..."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