SPLIT

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

Syntax

=SPLIT(string, separator)

Arguments

Argument	Type	Description
string	String	The string to split into an array
separator	String	Character 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