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. #(“a”,”b”) 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 from specified parameters such as numbers, boolean values, and strings. If a parameter is a string it is automatically split by specified separator. The separator is always the last parameter of the function.

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

Example

=ARRAY("a,b", "c,d", ",")

Result

#("a","b","c","d")

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