start_num should be a number between 0 to max length of the text string from which you want to search your text.
When you are searching for a whole word from another text string it will only return the starting position of that word.
In the below example, we are searching for alphabet “P” & 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.
Now, in the below example, we have used the search function to get the name of the month from another string.
I have used the search function to first locate the position of the first letter & then mid function and len function to extract a text string.
To learn more about Excel SEARCH Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.