The FIND function locates the position of a text string from another text string.
By using this function, you can find a single character as well as a complete word from a text string.
It returns the starting position of a text string in another text string.
In the below example, we are searching for alphabet “well” and we have specified start_num as 1 to start our search.
Our formula returns 12 as the position of the text. And, if you look at it, the word “well” starts from the 12th position in the text string.