ASARRAY

If the argument is not an array, returns an array containing the argument. Otherwise, returns the argument array.

Syntax

=ASARRAY(value)

Arguments

ArgumentTypeDescription
valueAnyThe value to be returned as an array

Examples

=ASARRAY(1)[1]

=ASARRAY("ABC")["ABC"]

=ASARRAY([1, 2, 3])[1, 2, 3]