How to use the Excel FINDB function

The FINDB function is to find the starting position of a text string from another text string.

Syntax: =FINDB(find_text, within_text, [start_num])

The FINDB function syntax has the following arguments:

• Find_text (Required) The text you want to find.
• Within_text (Required): The text containing the text you want to find.
• Start_num (Optional) Specifies the character at which to start the search. The first character in within_text is character number 1. If you omit start_num, it is assumed to be 1.

Example: Let’s look at some Excel FINDB function examples and explore how to use the FINDB function as a worksheet function in Microsoft Excel:

Syntax:  =FINDB(A2,B2,C2)

Result:

Based on the Excel spreadsheet above, the following FINDB examples would return: