The FIND function returns the starting position of one string within another.
FIND(search-string, source-string, start-pos)
search-string: The string value to find.
source-string: The string value to search.
start-pos: An optional number value that specifies the position within the specified string at which the action should begin. start-pos must be greater than or equal to 1 and less than or equal to the number of characters in source-string. If start-pos is omitted, it is assumed to be 1.
Notes
The search is case sensitive and spaces are counted. Wildcards are not allowed. To use wildcards or to ignore case in your search, use the SEARCH function.
Specifying start-pos permits you to begin the search for search-string within, rather than at the beginning of, source-string. This is particularly useful if source-string may contain multiple instances of search-string and you wish to determine the starting position of other than the first instance.
Examples |
|---|
=FIND(“e”, “where on earth”) returns 3 (“e” is the third character in the string “where on earth”). =FIND(“e”, “where on earth”, 8) returns 10 (“e” in earth is the first “e” found starting from character 8, the “n” in “on”). |