Split comma delimited string on comma replace comma with pipe then rejoin Join string

Can you explain why "decision sciences, ecosynomics" are excluded?

Apologies, that was an error on my part. I have corrected it

OK, so you want to split the string by the pattern of xxxxx - ie.
This is to show you how I do it for demonstration purpose.

Please Login or Register  to view this content.

If this is how you want to separate the string, I need to see your desired results(sheet layouts).

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

I don't know how "FullOptionLists" play the roll here, but only from col.H of your "RawData".
This is to show you how to separate,
If this is not kind of how you wanted, please wait for someone else to come in to help you.
Good luck.

Please Login or Register  to view this content.