Use

The TextSplit() function transforms a text value into a one dimensional array by splitting the text into array items wherever a specified delimiter is found.

TextSplit2() works similarly, but it splits the text into a two-dimensional array using two delimiters.

Examples

• TextSplit(";", "A;BC;D E;F")  = ["A", "BC", "D E", "F"]
• TextSplit(" ", "wish me good morning!")  = ["wish", "me", "good", "morning!"]