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:
Based on the Excel spreadsheet above, the following FINDB examples would return: