FIND Function

Returns the starting position (the number of characters in) of a string within text.
Sample Usage
FIND("D", [Task Name]4, 5)
Syntax
FIND(
  • search_for
  • text_to_search
  • [
    start_position
    ]
)
  • search_for
    —
    The text or a cell reference you want to find.
  • text_to_search
    —
    The text you want to search within.
  • start_position
    —[optional]
    The number of characters in, from the left, to begin searching. If a number isn’t provided, the search begins from the leftmost character.
Related Functions
SUBSTITUTE
REPLACE
LEFT
RIGHT
MID
VALUE
Was this article helpful?
YesNo