Functions
SPLIT
Split text into array by delimiter
Try it
When to use it
When should I use SPLIT?
Use SPLIT to break a delimited text string into an array of separate values, such as parsing a CSV row or splitting a full name into parts.
Used in
Syntax
SPLIT(text, delimiter, [split_by_each], [remove_empty])Examples
=SPLIT("1,2,3",",") // => 1