Description
SEARCH is a text function in Excel. Having three arguments, first two arguments are mandatory and third one is optional. First argument is find_text, the text you want to search, second one is within_text, the text string in which you want to search and the last is start_num, numbe of character in within_text from where you want to start the search, it’s default value is one. SEARCH is not case sensitive. If find_text is missing in within_text you will get #VALUE! error.
Syntax
SEARCH(find_text,within_text,[start_num])
Example
- If third option start_num is missing, SEARCH start the search from first character.
- Using third option start_num of SEARCH, you can start the search from the desired character.
- If find_text is missing in within_text, SEARCH will return #VALUE! Error.
- SEARCH is not case sensitive; hence, returned 1, “b” and “B” are same for SEARCH.
0 Comments