Jindon, thank you for your response. Your solution in very good for this example. Again thank you

I am trying for a more general solution.

In my real data which is dynamic and keeps changing cell values can be any kind of single word or sentence strung together with commas like The fox in brown, fast, hungry, Orange, ABC, XYZ, LMN

where the sub-strings are
The fox in brown, fast, hungry
ABC, XYZ, LMN
Orange

That is why I what to use the "FullOptionLists" sheet so I can indicate what are the sub-string for each column

I regret if I was un-clear in my question

Any further help with this is greatly appreciated