The Excel FIND function returns the position of a specified character or sub-string within a supplied text string.
The function is case-sensitive. If you want to perform a non-case-sensitive search, use the Excel Search function instead.
The syntax of the Find function is :
Where the function arguments are:
|find_text||-||The character or sub-string that you wish to find.|
|within_text||-||The text string that is to be searched.|
|[start_num]||-||within_text string)If omitted, this takes on the default value of 1 (i.e. begin the search at the start of the|
If the supplied find_text is found, the Find function returns a number that represents the position of the find_text in the within_text. If the supplied find_text is not found, the function returns the Excel #VALUE! error.
Column B of the following spreadsheet shows examples of the Excel Find function used to find various characters in the text string "Original Text".
Note that, in the above spreadsheet:
Further examples of the Excel Find function are included in the split string in Excel page.
Also, further information and examples of the Find function are provided on the Microsoft Office website.
If you get an error from the Excel Find function this is likely to be the #VALUE! error: