The FINDB function is to find the starting position of a text string from another text string.
Same as the FIND function, the FINDB function is case sensitive.
Formula:
=FINDB(find_text, within_text, [start_num])
Explanations:
– The find_text is required, which is the text you need to find;
– The within_text is required, which is the text string that contains the text you need to find.
– [Start_num] is optional, which specifies the start searching point. When it is omitted, the default start searching point is the first character of the string.
Cautions:
– When a language that supports double-byte character set (DBCS) is enabled and set to as the default language, the FINDB function counts each double-byte character as 2. Otherwise, the FINDB function counts each character as 1.
– Wildcard character is not allowed with the FINDB function.
Example:
=FINDB("o",A2)
The result returns to the position of the first letter "o", which is 2.
=FINDB("o",A4,3)
The result returns to the position of the letter "o" when searching from the 3rd letter.
=FINDB("FIND",A5,3)
The FINDB function returns to the position of the first letter of word "FIND", which is 12.
