FIND()

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.

Syntax

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

CONTAINS()

IN()

STARTSWITH()

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