How to Use FIND in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: FIND returns the position of the first match of some text inside another string. The formula is =FIND(search_for, text_to_search, [starting_at]). It is case sensitive.

What FIND does

FIND tells you where something is inside a piece of text. That position is most useful as input for other functions, such as LEFT, RIGHT and MID, when you need to cut text at a character that is not always in the same place.

FIND syntax

=FIND(search_for, text_to_search, [starting_at])

Google's help page notes that FIND is case sensitive (use SEARCH for a case-insensitive search), returns #VALUE! if nothing matches, and that its argument order differs from SPLIT and SUBSTITUTE: the text you look for comes first.

A step-by-step example

Cell A2 holds the code INV-2026-0042.

A
1Code
2INV-2026-0042

To find the first hyphen:

=FIND("-", A2)

This returns 4. The characters are I (1), N (2), V (3) and the hyphen (4).

Start the search later

Use the third argument to skip ahead. To find the next hyphen, begin the search after the first one:

=FIND("-", A2, 5)

This returns 9. Together with MID, these positions let you extract the text between the two hyphens, even when its length changes from code to code.

Common mistakes

Try it yourself

Use the code above (A2 holds INV-2026-0042). Type your formula into the box, starting with =, then press Check.

Exercise 1: First hyphen

Write a formula that returns the position of the first hyphen in A2.

Hint: FIND("-", A2).

Exercise 2: Second hyphen

Write a formula that returns the position of the second hyphen in A2 by starting the search after the first one (which is at position 4).

Hint: use the third argument, a start position of 5 or later.

What to learn next

Syntax and rules in this guide were checked against Google's FIND help page. See all guides.