you’re able to also use FIND to test whether a cell contains specific text.
FIND is case-sensitive, which means it distinguishes between uppercase and lowercase letters.
This behavior is automatic and cannot be disabled.
Both functions return the position of one text string inside another.
However, unlike FIND, SEARCH isnotcase-sensitive anddoessupport wildcards.
When FIND locates the substring, it returns the position of the substring in the text as a number.
If the substring is not found, FIND returns a #VALUE error.
To force a TRUE or FALSE result, you cannestthe FIND function inside theISNUMBER function.
ISNUMBER returns TRUE for numeric values and FALSE for anything else.
For a more detailed explanation of this approach, with many more examples,see this example.
you might use the same idea to mark or “flag” items of interest.
We then add 1 and the result is used as thestart_numin the outer FIND.
The result is the location of the second “x” in cell A1.
Wildcards
The FIND function does not support wildcards.
More advanced formulas
The FIND function shows up in many more advanced formulas that work with text.
SEARCH returns the position offind_textinsidewithin_textas a number.
For example =REPLACE(“XYZ123”,4,3,“456”) returns “XYZ456”.
SUBSTITUTE Function
The Excel SUBSTITUTE function replaces text in a given string by matching.
SUBSTITUTE is case-sensitive and does not support wildcards….
