What is the use of FIND function?
FIND Function in Excel returns the location or position of a sub-string in a text string.
1. The find function is case-sensitive.
2. Search & Find performs the same task, But find is case sensitive.
What is the syntax of FIND function?
: The substring that you want to find.
: The string containing the text you want to find.
: It is optional. The character at which to start the search. If omitted, this takes on the default value of 1
1. If find_text does not appear in within_text, FIND and FINDB return the #VALUE! error value.
2. If start_num is not greater than zero, FIND and FINDB return the #VALUE! error value.
3. If start_num is greater than the length of within_text, FIND and FINDB return the #VALUE! error value.
FIND Function in Excel – Examples