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.
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
FIND(UPPER("Red"), UPPER("I'm bored!")) returns 7 because the all-uppercase
RED occurs at that position in the all-uppercase
FIND("@", [Email]) returns the position of the first at sign (@) in Email, or 0 if not present.
haystack- Any text value in which the text fragment (
needle) is to be sought.
needle- Any text fragment to find in search value (