Excel SEARCH Function can locate 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 will return the position number of the first character of the text which you are finding from the text string.
find_text Text string which you want to find from the other text string. This can be a single text string or a word.
within_text Text string from which you want to locate the text. You can refer to a cell or you can input a text in your function.
[start_num] A number which represents the position in within_text to start the search for the find_text.
More Information About Excel SEARCH Function
- The search function is not a case sensitive. You can use find function if you want to search for a case-sensitive text.
- A single cell can be referred at a time.
- You can also use wildcard characters (* ? ~) in the search function.
- 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 above 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 above example, we have used the search function to get the name of the month from another string .
What is Next?
To learn more about Excel SEARCH Function you can check Microsoft’s Help Section.
And, if you have a unique idea to use the search function, I would love to hear from you.