SEARCH Function Explained
The SEARCH function in Microsoft Excel is used to locate a specified string of text within a larger string of text. It returns the position of the specified string within the larger string, or a #VALUE! error if the specified string is not found. The SEARCH function takes three arguments: find_text, within_text, and start_num. The find_text argument is the string of text to be found, the within_text argument is the larger string of text to be searched, and the start_num argument is an optional argument that specifies the character position in the larger string to begin the search.
SEARCH Function Syntax
SEARCH(find_text, within_text, [start_num])
- find_text: The text you want to find. It can be a number, text, or a logical value.
- within_text: The text or cell you want to look in.
- start_num: (optional) The character at which to start the search. The first character in within_text is character number 1.