ASARRAY

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

Syntax

=ASARRAY(value)

Argument	Type	Description
value	Any	The value to be returned as an array

=ASARRAY(1)→[1]

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

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

Updated 9 months ago