The SEARCH function locates the position of a text string from another text string.
You can search for a single character as well as for a word from a text string. It returns the position number of the first character of the text which you are finding.
In the below example, we are searching for alphabet "P" and we have specified start_num as 1 to start our search.
Our formula returns 1 as the position of the text.
But, if you look at the word, we also have a "P" at 6th position.
That means search function can only return the position of the first occurrence of a text, or if you specify the start position accordingly.