SPLIT

按指定分隔符分割字符串。

依照指定分割符分割字符串，返回分隔后的字符串数组。

语法

SPLIT(str, separator)

• str：必需，要分割的字符串。
• separator：必需，分隔符，如 ","、" "、"|"、"-"、"." 等。

示例地址： SPLIT (opens new window)

示例

1. SPLIT("a，b，c","，") 按，（中文逗号）分割，返回数组["a","b","c"]
2. SPLIT("abc 123 文字"," ") 按空格分割，返回数组["abc","123","文字"]
3. SPLIT("一句话。下一句。再下一句","。") 按句号分割，返回数组["一句话","下一句","再下一句"]
4. SPLIT(A1,"-") 按-分割单元格A1的值
5. SPLIT("abc 123 文字","") 分割符为空字符串时将逐个字符分割，返回数组["a","b","c"," ","1","2","3"," ","文","字"]
6. SPLIT("a？bc<>d efg",null) 分割为null时没有可分割的内容，返回数组["a？bc<>d efg"]
7. SPLIT("",",") 带分割字符串为空串时返回空数组[]
8. SPLIT(null,",") 带分割字符串为空串时返回null