Hi all,
Can a FIND or SEARCH formula be limited to detect multiple 'OR' values only if the values are the first or last in a string? (I don't need a single formula that checks for both conditions; I can use 2 formulas if it's significantly easier).
For example, can =OR(ISNUMBER(SEARCH({"dog","mouse","elephant"},A1))) be modified to detect "Dog 123" or "Mouse123 ABC" or "123 XYZ Elephant" while ignoring cells containing any of the values in an intermediate position?
Thanks for any help!
Bookmarks