How to use the Excel FIND function

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.

excel find function 4 - How to use the Excel FIND function

Syntax:  =FIND(A2,B2)

excel find function 3 - How to use the Excel FIND function

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.

excel find function 2 - How to use the Excel FIND function

Syntax:  =FIND(A2,B2,C2)

Result:

excel find function 1 - How to use the Excel FIND function

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

Add a Comment

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