SPLIT
Description
Splits a string into multiple strings. This function is useful when the string has
boundaries that you can match using a regular expression.
Syntax
SPLIT(
text
,
regex
)
- text: The text to split.
- regex: The regular expression, specified as text, to use to find the location of the split.
Example
Formula | Result |
|---|---|
=SPLIT("a,b,c,d", ",") | a
b
c
d
|
Notes
- The SPLIT() function is useful when you want to break a string into pieces and the string has boundaries that you can match using a regular expression. Example: In the string "a,b,c,d", you can split on the "," character to produce 4 separate strings: "a", "b", "c", and "d".
- This function is intended for use in array formulas.