Microsoft Excel Tips and Tricks
In this video I demonstrate how to perform a wildcard “contains” test in an IF statement. You cannot use the wildcard characters *, ! in a logical test. The workaround is to use SEARCH and ISNUMBER.
Credit Chester Tugwell