Exceljet

Quick, clean, and to the point

Excel FIND Function

Excel FIND function
Summary 

The Excel FIND function returns the position (as a number) of one text string inside another. When the text is not found, FIND returns a #VALUE error.

Purpose 
Get the location of text in a string
Return value 
A number representing the location of find_text.
Syntax 
=FIND (find_text, within_text, [start_num])
Arguments 
  • find_text - The text to find.
  • within_text - The text to search within.
  • start_num - [optional] The starting position in the text to search. Optional, defaults to 1.
Usage notes 
  • The FIND function will return the location of the first instance of find_text in within_text.
  • The location is returned as the number of characters from the start of within_text.
  • Start_num is optional and defaults to 1.
  • FIND will return #VALUE if find_text is not found in within_text .
  • FIND is case-sensitive and does not support wildcards.
  • Use the SEARCH function to search without case-sensitivity and/or to use wildcards.