SEARCHB Function Explained
The SEARCHB Function in Microsoft Excel is used to find the position of one text string within another text string. It is case-sensitive and searches from the end of the text string. It returns the position of the first character of the text string found, or a #VALUE! error if the text string is not found.
SEARCHB Function Syntax
SEARCHB(find_text, within_text, [start_num])
- find_text – The text you want to find. It can be a string of characters or a cell reference.
- within_text – The text you want to search in. It can be a string of characters or a cell reference.
- start_num – [Optional] The character position in within_text where you want to start searching. If omitted, the search begins at the first character of within_text.