With the Text Toolkit for Excel, you can easily split cells by characters, strings, or mask. In this manual, find out how to use the Split Text utility.
Select the Split by strings or characters radio button if text in your cells has some characters or strings by which you want to split your cells, and these characters may appear in different order and combinations.
For instance, if you've got "AxyByxC" and want to split it into three columns, you enter "x" and "y" into the input field and get the result " A | B | C ".
For instance, your data set is "AxByCxyDyxE" and you want it to be split by "x", "y", and all their combinations: "xy" and "yx". You enter "x" and "y" into the input field and check the Treat consecutive delimiters as one box:
The cell will be divided according to all the relevant combinations:
For instance, you've got the same "AxByCxyDyxE" data set and want to get the same A | B | C | D | E result. In this case, you'll have to enter all the delimiters in the order they appear in the string and divide them by the * sign: *x*y*xy*yx*:
So, with the Split by mask option, it is very important to indicate all the delimiters in the accurate order of their appearance in your cells and separate them by the * sign.