FIND Formula

FIND formula returns the location of a sub-string in a string. The search is case-sensitive.

Syntax

FIND(find_text, within_text, [start_num] )

Parameters Details:

  • find_text : The sub-string that you want to find.
  • within_text : The string to search within.
  • start_num : Optional. It is the position in string where the search will start. The first position is 1.

Returns

The FIND function returns a numeric value. The first position in the string is 1.
If the FIND function does not find a match, it will return a #VALUE! error.