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
Updated 9 months ago