Split splits a string into substrings based on a delimiter and returns the substring based on the index.
SYNTAX:
SPLIT(Expression,Delimiter,Index)
Expression: The string to split. Can be a quoted string ("1,2,3") or a cell reference (B2).
Delimiter: The character(s) that is placed between each value.
Index: Sets which substring to return, to get the first substring 1, second 2...
NOTES:
Returns a Text string. Cell type will be changed to Text when using this formula.
EXAMPLES:
SPLIT("2,4,6",",",2) = 4
SPLIT(B2," ",2) = Returns "Dorner" if B2 = "Scott Dorner"
SEE ALSO: Join, CONCAT