These docs are for v1.0. Click to read the latest docs for v1.2.

SPLIT

Splits the specified string into an array at the specified separator.

Syntax

=SPLIT(string, separator)

Arguments

ArgumentTypeDescription
stringStringThe string to split into an array
separatorStringCharacter at which to split the string

Examples

=SPLIT("A_B_C_D", "_")["A", "B", "C", "D"]
Splits the string "A_B_C_D" at every underscore found

=SPLIT("Hello", "")["H", "e", "l", "l", "o"]
Splits the string "Hello" at every character