Spreadsheet formulas explained, side by side

FIND Function in Excel, Google Sheets, Airtable & Notion

FIND returns the position where one text string first appears inside another, counting from 1. FIND("-", "INV-2024-0042") is 4. It is case-sensitive and returns #VALUE! when the text isn't there.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inFIND(find_text, within_text, [start_num])
Google Sheets✔ Built inFIND(search_for, text_to_search, [starting_at])
Airtable✔ Built inFIND(stringToFind, whereToSearch, [startFromPosition])
Returns 0 when not found instead of an error. Positions in the result start at 1. When you need a start position, the tester searches a MID() of the text instead of passing the third argument, so the result matches Excel exactly.
Notion≈ Workaroundif(contains(text, find), length(split(text, find).at(0)) + 1, 0)
Notion has no position function. The length of the text before the first match, plus 1, gives Excel's position. contains() is case-sensitive like FIND. Returns 0 when not found.
Try FIND with your own values
Result (as Excel & Google Sheets return it)
4
Your formula, ready to paste
Excel=FIND("-", "INV-2024-0042") open excel.new ↗
Google Sheets=FIND("-", "INV-2024-0042") open sheets.new ↗
AirtableFIND("-", "INV-2024-0042")
Notion
workaround
if(contains("INV-2024-0042", "-"), length(split("INV-2024-0042", "-").at(0)) + 1, 0)

Arguments

ArgumentWhat it means
find_textThe text to look for. Case-sensitive; no wildcards.
within_textThe text to search in.
[start_num] optionalCharacter position to start searching from. Defaults to 1.

Examples

FormulaResultWhyCopy
=FIND("-", "INV-2024-0042")4First dash.
=FIND("-", "INV-2024-0042", 5)9Start after the first dash to find the second.
=FIND("inv", "INV-2024-0042")#VALUE!Case-sensitive: use SEARCH to ignore case.
=IFERROR(FIND("@", A2), 0)0 if missingTurn the error into 0, which is what Airtable returns.

Examples use Excel / Google Sheets syntax unless noted.

How FIND works

FIND is rarely the final answer; it supplies positions to LEFT, MID and RIGHT. =LEFT(A2, FIND(" ", A2) - 1) gets the first word, and =FIND("-", A2, FIND("-", A2) + 1) finds the second dash by starting just after the first.

FIND and SEARCH differ in two ways: FIND is case-sensitive and does not support wildcards, while SEARCH ignores case and understands * and ?. Both return #VALUE! when nothing is found, so to test whether text contains something use =ISNUMBER(FIND("x", A2)), or wrap the formula in IFERROR.

In Airtable, FIND returns 0 instead of an error, so IF(FIND("x", {Notes}), …) works directly as a “contains” test. Notion has no function that returns a position. For a yes/no test use contains(). For the position, measure the text before the first match, as the copy button does.

Frequently Asked Questions

How do I check if a cell contains some text?
Use =ISNUMBER(FIND("text", A2)) for a case-sensitive check or =ISNUMBER(SEARCH("text", A2)) to ignore case. Airtable: FIND("text", {Field}) > 0. Notion: contains(prop("Field"), "text").
How do I find the last occurrence of a character?
Replace the last one with a marker and find that: =FIND("#", SUBSTITUTE(A2, "-", "#", LEN(A2) - LEN(SUBSTITUTE(A2, "-", "")))).

Part of the Text functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.