“zzzz”, “####”, etc.)
Case-sensitive option
SEARCH is not case-sensitive.
since “dr” appears inside these words.
This happens because SEARCH automatically performs a “contains” match.
For a partial fix, you’re free to add space around the search words (i.e. "
dr “, or “dr “) to avoid catching “dr” in another word.
This can be partially addressed by adding space also around the original text.
Then you’re able to search for whole words surrounded by spaces.
SEARCH returns the position offind_textinsidewithin_textas a number.
When the text is not found, FIND returns a #VALUE error.
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
