Can Excel use wildcards to determine if a cell contains specific text?

Posted on


If A1 contains miles, the following evaluation is true:


If A1 contains miles and miles, the following evaluation return false:


Every resource I find uses (what looks to me) like a backdoor way of identifying the string, by searching for its location:


This accomplishes the task, but can Excel use wildcards to evaluate whether or not a longer string contains a smaller string?



Returns TRUE if A1 contains miles and FALSE if it does not. (Case insensitive)

You can also use Countif() with wildcards


Returns a 0 when not found. Perfect for IF statements.

Leave a Reply

Your email address will not be published. Required fields are marked *