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.
=FINDB(find_text, within_text, [start_num])
- 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.
- 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.
The result returns to the position of the first letter "o", which is 2.
The result returns to the position of the letter "o" when searching from the 3rd letter.
The FINDB function returns to the position of the first letter of word "FIND", which is 12.