Excel Wildcard IF – NOT WORKING! | If Cell Contains Text Then…

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