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:

Excel FINDB - How to use the Excel FINDB function

Syntax:  =FINDB(A2,B2,C2)


Excel FINDB function - How to use the Excel FINDB function

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

Syntax: =FINDB(A3,B3,C3)
Result: 13

Syntax: =FINDB(A4,B4,C4)

Result: 10

Syntax: =FINDB(A5,B5,C5)
Result: 9

Syntax: =FINDB(A6,B6,C6)
Result: 15

READ:  How to use Day function in excel

Add a Comment

Your email address will not be published. Required fields are marked *