FIND Function in Excel – Find the position of the string in Excel

FIND Function in Excel returns the position of a specified character or sub-string within a supplied text string.

FIND Function is case sensitive whereas Search Function is not case sensitive.

 

Syntax of FIND Function in Excel:

Where,

• find_text – The character or sub-string that you wish to find the position of.
• 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. Default is 1 which begin the search at the start of the within_text string.

 

Example of FIND Function in Excel

Formula

• Row number 2 to 5 returns the position of the given substring in the corresponding string
• Row number 6 returns position of the occurrence of “i” in the string (first occurrence)
• Row number 7 returns position of the occurrence of “i”, starting from the 10^th character of the string.
• Row number 8 returns position of the occurrence of “INDIA”, since the FIND Function is case sensitive it returns the #VALUE! Error.

Result

NOTE: #VALUE! Error Occurs if

• The supplied find_text is not found in the supplied within_text string