Google Sheets FIND Function: Syntax, Examples & Tips

search_for:
The string or character that you want to find within the text_to_search.

text_to_search:
The text or cell reference in which you want to search for the search_for string.

starting_at:
(Optional) The position in the text_to_search from which to start the search. If omitted, the search begins at the start of the text.

What is a FIND Function in Google Sheets?

The FIND function in Google Sheets is a useful tool that allows you to locate the position of a specific substring within a string of text. It returns the index of the first occurrence of the substring, making it a valuable function for text manipulation and analysis. Unlike the SEARCH function, FIND is case-sensitive and does not support wildcard characters.

In simpler terms, FIND helps you determine where a particular piece of text appears within a larger text string.

A Practical Example

Imagine you have a list of email addresses in a Google Sheets document, and you want to find the position of the "@" symbol in each email address.

Email Addresses Table:

FIND Formula

To achieve this, you would use the FIND function as follows:

=FIND("@", A2)

In this formula:

• "@" is the substring you are searching for.
• A2 is the cell containing the email address you want to analyze.

Result of the Formula

When you apply the FIND formula to the Email Addresses Table, the output would look like this:

The FIND function returns the position of the "@" symbol for each email address, allowing you to quickly identify its location.

Why Use FIND?

FIND is beneficial because it provides a straightforward way to locate specific characters or substrings within text. This can be particularly useful for data cleaning, validation, and extraction tasks. Additionally, since FIND is case-sensitive, it allows for precise text searches.

Key Takeaways:

• FIND: A function that locates the position of a substring within a string of text.
• Case-Sensitive: Unlike SEARCH, FIND distinguishes between uppercase and lowercase letters.
• Text Manipulation: Ideal for tasks involving text analysis, validation, and extraction.
• Common Use Cases: Useful for email validation, data cleaning, and any scenario where specific text positions need to be identified.

FIND is an essential function for anyone working with text data in Google Sheets, providing a powerful way to enhance text analysis and manipulation capabilities.

Happy spreadsheeting!