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.|
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: