Formulas and Functions
Modifying this control will update this page automatically

FIND

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").

=FIND(REGEX("([A-Z0-9a-z._%+-]+)@([A-Za-z0-9.-]+\.[A-Za-z]{2,4})"), "Where does marina@example.com start?") returns 12, the starting position of the first email in the source string.

See alsoEXACTSEARCH
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.