FINDB Function Explained
The FINDB function in Microsoft Excel is used to locate the position of a substring within a string. It returns the starting position of the substring within the string, or a #VALUE! error if the substring is not found. The syntax for the FINDB function is FINDB(find_text, within_text, [start_num]), where find_text is the substring to be found, within_text is the string to search in, and start_num is an optional argument that specifies the character at which to start the search.
FINDB Function Syntax
FINDB(find_text, within_text, [start_num])
- find_text: The text you want to find. It can be a number, text, or a cell reference.
- within_text: The text or cell you want to search in.
- start_num: (optional) The character at which to start the search. If omitted, the search begins at the first character of within_text.