I'd like to make a validation rule that prohibits the entry of certain characters in a given cell. For example, if my search set of characters are
("/","&","%"), then I should get the following search results:
"Test, test" = false "Te/st" = true "Test...test&"= true
and the second two examples should not be allowed.
I guess I'm looking for something similar to SQL's WHERE...IN grammar. How would I do this in Excel? I know I can just use OR() or nested IF() statements, but I'm wondering if there's something cleaner.