Excel provides a wide variety of text and numeric data processing tools. Two popular search functions are FIND and SEARCH. These are similar functions. First, I will discuss the FIND function.
The FIND function in Excel is used to return the position of a specific character or substring within a text string.
The breakdown of this is:
If the FIND function does not find the find_text character(s), a #VALUE! error is returned.
I will explain this with three easy examples.