The FIND function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function in Excel. As a worksheet function, the FIND function can be entered as part of a formula in a cell of a worksheet.
Syntax: =FIND (find_text, within_text, [start_num])
The FIND function syntax has the following arguments:
| find_text | – | The character or sub-string that you wish to find. |
| within_text | – | The text string that is to be searched. |
| [start_num] | – |
An optional argument that specifies the position in the within_text string, from which the search should begin. If omitted, this takes on the default value of 1 (i.e. begin the search at the start of the within_text string) |
Let’s look at some Excel FIND function examples and explore how to use the FIND function as a worksheet function in Microsoft Excel:
Example 1.
Syntax: =FIND(A2,B2)
Result:
Syntax: =FIND(A3,B3)
Result: 6
Syntax: =FIND(A4,B4)
Result: 1
Syntax: =FIND(A5,B5)
Result: 5
Syntax: =FIND(A6,B6)
Result: 5
Example 2.
Syntax: =FIND(A2,B2,C2)
Result:
Syntax: =FIND(A3,B3,C3)
Result: 6
Syntax: =FIND(A4,B4,C4)
Result: 4
Syntax: =FIND(A5,B5,C5)
Result: 5
Syntax: =FIND(A6,B6,C6)
Result: 18
