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?
TRUE if A1 contains
FALSE if it does not. (Case insensitive)
You can also use Countif() with wildcards
Returns a 0 when not found. Perfect for IF statements.