Split String into many columns according to Format criteria

Hello everyone,
I have about 100 000 rows containing dictionary data (pashto-english). I have to split each string into many columns according to their format.

I am attaching an Excel 2007 file containing example data. Worksheet “is” contains real data as it is now and worksheet “should be” contains how it should look like after. In 2nd Row of the ws “should be” I have entered the criteria according to which the strings are to be broken.
It’s very very important that I find solutions for this. I hope that someone can help me out with it.

Many thanks in advance!