What is the FIND Function?
The FIND Excelfunctionfinds the position of a given string from a particular selection.
TheFind and Replacefeature, not this function, is used to search through an Excel workbook.
Given that the cell readsLifewire, the result of thisformulais5.
Ifwwere written in D2, this would produce the same result as the first example.
Those first two examples show the basics of the FIND function.
In this case, it’s the first nameEmily.
The subtraction at the end is to offset the function by two characters.
Extract Number From Cell With MID Function
This example of the FIND function is bit more complex.
