FormulaCraft

FIND / SEARCH

FIND and SEARCH return the starting position of a substring within text. FIND is case-sensitive; SEARCH ignores case and allows wildcards. Both pair well with LEFT/MID to extract parts of a string.

Excel
=FIND("@", A2)
Google Sheets
=FIND("@", A2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1"@" is the text to locate.
  2. 2A2 is the string to search within.
  3. 3The result is the character position; use SEARCH instead for a case-insensitive match.

Need a version for your data?

Try: “Find the position of the @ sign in the email in A2”

Related

TEXTJOINLEFT / RIGHT / MIDTRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: