Position of fragment in text

Returns the position (Number) of a value in a text fragment, or zero (0) if not found.

Note: The search is case-sensitive: upper- and lower-case letters are considered unique.

Sample usage

FIND("a", "abc") returns 1

FIND("bc", "abc") returns 2

FIND("d", "abc") returns 0

FIND("Red", "I'm bored!") returns 0 because Red, with an uppercase R, doesn't occur in I'm bored!.

FIND(UPPER("Red"), UPPER("I'm bored!")) returns 7 because the all-uppercase RED occurs at that position in the all-uppercase I'M BORED!.

FIND("@", [Email]) returns the position of the first at sign (@) in Email, or 0 if not present.


FIND(needle, haystack)

  • haystack - Any text value in which the text fragment (needle) is to be sought.
  • needle - Any text fragment to find in search value (haystack).

See also




Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center