Site icon ExcelNotes

How to Use FINDB Function

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.

Download: FINDB Function

Exit mobile version