Spreadsheet formulas explained, side by side

SEARCH Function in Excel, Google Sheets, Airtable & Notion

SEARCH works like FIND but ignores upper and lower case and accepts the wildcards * and ?. SEARCH("report", "Q3 Sales Report") is 10.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inSEARCH(find_text, within_text, [start_num])
Google Sheets✔ Built inSEARCH(search_for, text_to_search, [starting_at])
Airtable✔ Built inSEARCH(stringToFind, whereToSearch, [startFromPosition])
Returns empty (not an error) when not found, and has no wildcards. To be sure case is ignored, the tester lowercases both sides: SEARCH(LOWER(find), LOWER(text)).
Notion≈ Workaroundif(contains(lower(text), lower(find)), length(split(lower(text), lower(find)).at(0)) + 1, 0)
No SEARCH in Notion. Lowercase both sides and measure the text before the first match. For a simple yes/no, contains(lower(text), "word"); for wildcard-style patterns, test() with a regular expression.
Try SEARCH with your own values
Result (as Excel & Google Sheets return it)
10
Your formula, ready to paste
Excel=SEARCH("report", "Q3 Sales Report") open excel.new ↗
Google Sheets=SEARCH("report", "Q3 Sales Report") open sheets.new ↗
AirtableSEARCH(LOWER("report"), LOWER("Q3 Sales Report"))
Notion
workaround
if(contains(lower("Q3 Sales Report"), lower("report")), length(split(lower("Q3 Sales Report"), lower("report")).at(0)) + 1, 0)

Arguments

ArgumentWhat it means
find_textThe text to look for. Not case-sensitive. ? matches one character, * any run of characters; ~* finds a literal asterisk.
within_textThe text to search in.
[start_num] optionalCharacter position to start from. Defaults to 1.

Examples

FormulaResultWhyCopy
=SEARCH("report", "Q3 Sales Report")10Case is ignored.
=SEARCH("r?port", "Q3 Sales Report")10? matches any single character.
=ISNUMBER(SEARCH("urgent", A2))TRUE / FALSEThe standard “contains” test.
=SEARCH("x", "abc")#VALUE!Not found is an error; wrap in IFERROR if needed.

Examples use Excel / Google Sheets syntax unless noted.

How SEARCH works

SEARCH is the one to use for “does this cell mention…” checks, because people rarely type case consistently. =ISNUMBER(SEARCH("refund", A2)) returns TRUE whether the note says Refund, REFUND or refund, and works well inside IF, FILTER or conditional formatting. Use FIND only when case matters.

Wildcards make SEARCH more flexible: ? stands for one character and * for any number, so SEARCH("inv*2024", A2) matches “INV-0042 2024”. To look for a real ? or *, put a tilde in front: SEARCH("~?", A2). For anything more complex, use REGEXMATCH.

Airtable's SEARCH returns an empty value when the text isn't found (FIND returns 0), and it has no wildcards. Lowercasing both arguments guarantees a case-insensitive match. Notion has no position function, but contains(lower(prop("Notes")), "refund") covers the common yes/no case.

Frequently Asked Questions

What is the difference between SEARCH and FIND?
SEARCH ignores case and allows * and ? wildcards. FIND is case-sensitive and treats every character literally. Both return #VALUE! when nothing is found in Excel and Google Sheets.

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