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