How to split a string based on a sub string

I can force my users to enter a constant sting of "w/o", would simplify it a little?

I am confused by the 'w/o'...and it can be hard to change users behavoir in excel, especially if they are undertrained. I try to code around their habits.

With the setup in my post, the only necessary parts are the words is and can. "************is &&&&&&& can **********" will give you:

*********is

&&&&&&&&&

can ********

in three separate cells.

Happy Excelling