A cell receives input that can be any combination of "PRICE", "NO BOL", or other word(s).
How do I search that cell for the other word(s) that is not "PRICE" or "NO BOL" and copy the other word(s) into a variable?
I feel like there is a very simple function call that I havent found yet.
Thanks.
-Luke