ARRAYSORT

This function creates an array in which the items of an existing array are sorted in ascending order.

Syntax

=ARRAYSORT(array)

Example

Cell D3 contains this array:

#(1,123,789,TRUE,FALSE,"test","a","b","c","d",1)

The function =ARRAY(D3) returns this array:

#(1,123,789,"a","b","c","d","test","FALSE","TRUE")