Skip to main content

APPEND

Use the APPEND function to join together items from two arrays.

Use

APPEND( array1, array2 )
Adds the items from the second array to the end of the first array.

ParameterRequiredDescription
array1Yesan array (any type) that will have the items from array2 added to the end
array2Yesan array (any type) who items will be added to the end of array1

ReturnsArray matching the type of array1

Example 1

Function ...

returns ...

ON THIS PAGE