SheetFX
≡
<< Go back to all functions

FIND

The FIND function in Google Sheets is a useful tool to determine the position at which a string is first found within a text. Whether you're searching for specific words, characters, or substrings, the FIND function simplifies the task. Explore our comprehensive guide to learn more about its syntax and usage.

Function Syntax and Parameters

Syntax: FIND(search_for, text_to_search, [starting_at])

Parameters:

  • search_for: The string or character you want to search for.
  • text_to_search: The text within which you want to perform the search.
  • starting_at: [Optional] The position in the text where the search should start.

Step-by-Step Tutorial

  1. Using FIND to search for a word:

    • Example: =FIND("apple", "I have an apple")
    • Result: 10

  2. Using FIND to search for a character:

    • Example: =FIND("e", "She sells seashells by the seashore")
    • Result: 7

  3. Using FIND with a starting position:

    • Example: =FIND("e", "She sells seashells by the seashore", 8)
    • Result: 24

Use Cases and Scenarios

  1. Text Analysis: Determine the position of specific words within a paragraph.
  2. Data Extraction: Find the position of a specific character within a URL.
  3. String Manipulation: Search for substrings to perform conditional operations.

Related Functions

  • SEARCH: Perform a case-insensitive search within text.

Related Articles