The FIND function in Excel is used to find the location of specific text within a text. The FIND function return a number (which is first appearance of the searched text).
Syntax of FIND Function
FIND function example:
Just to explain FIND function better, I have prepared this data.
In Cell D2 to D4, I want to find the location of “Hero” in cell B2, “@” in cell B3 and “a” in B4, respectively.
I write this FIND formula in Cell D2 and drag it down to cell D4.
And now i have the location of the given text:
1. To just know if a text is present in given cell or not.
Use ISNUMBER with excel FIND function.
ISNUMBER returns true if gets input as a number.
FIND returns found location as an whole number (integer).
2. To Trim TEXT using LEFT and RIGHT
The FIND function is excessively used with LEFT and RIGHT functions to extract specific texts. To learn in detail see this article.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.