ARRAYINSERT

This function creates an array by referencing an existing array and adding specified items.

Syntax

=ARRAYINSERT(array,index,value {,value})

Example

In this example, cell F19 contains this array, created with the ARRAY function:

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

ARRAYINSERT creates an array to which the values Yes and No are added as the first and second items:

=ARRAYINSERT(F19,1,"Yes","No")

This is the resulting array:

#("Yes","No",123,789,FALSE,"Test","a","b","c")