Related Function:

The FIND and FINDB functions locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.

Syntax

=FIND(find_text,within_text,[start_num])

=FINDB(find_text,within_text,[start_num])

Note:

Arguments

Argument Description
find_text The text you want to find
within_text The text containing the text you want to find
[start_num] Specifies the character at which to start the search. The first character in within_text is character number 1. If [start_num] is omitted, it is assumed to be 1

Note: The FIND and FINDB are case sensitive and don’t allow wildcard characters

  • If find_text is “” (empty string), FIND matches the first character in the search string, i.e. the character numbered [start_num] or 1
  • Use start_num to skip a specified number of characters

Examples

  A B C
1 Data    
2 Google Glass    
3      
4 Formula Result Notes
5 =FIND(“G”,A2) 1 Position of the first “G” in the text string
6 =FIND(“g”,A2) 4 Position of the first “g” in the text string
7 =FIND(“G”,A2,3) 8 Position of the first “G” in the text string, starting with the 3rd character
8 =FIND(“”,A2,3) 3 find_text is “” (empty text) and have start_num – returns start_num
9 =FIND(“”,A2) 1 find_text is “” (empty text), returns 1
10 =FIND(“X”,A2) #VALUE! find_text does not appear in the within_text
11 =FIND(“”,A2,-3) #VALUE! start_num is got greater than zero
12 =FIND(“G”,A2,14) #VALUE! start_num is greater than the length of within_text (12 characters)

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either:

  the supplied find_text is not found in the supplied within_text string
  the supplied [start_num] is less than zero or is greater than the length of the supplied within_text string