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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | FIND(find_text, within_text, [start_num]) |
| Google Sheets | ✔ Built in | FIND(search_for, text_to_search, [starting_at]) |
| Airtable | ✔ Built in | FIND(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 | ≈ Workaround | if(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. |
| Excel | =FIND("-", "INV-2024-0042") | open excel.new ↗ |
|---|---|---|
| Google Sheets | =FIND("-", "INV-2024-0042") | open sheets.new ↗ |
| Airtable | FIND("-", "INV-2024-0042") | |
| Notion workaround | if(contains("INV-2024-0042", "-"), length(split("INV-2024-0042", "-").at(0)) + 1, 0) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
find_text | The text to look for. Case-sensitive; no wildcards. |
within_text | The text to search in. |
[start_num] optional | Character position to start searching from. Defaults to 1. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=FIND("-", "INV-2024-0042") | 4 | First dash. | |
=FIND("-", "INV-2024-0042", 5) | 9 | Start 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 missing | Turn 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, "-", "")))).