fx =SEARCH("word",A1)ABCJohnSmithJohn SmithJaneDoeJane DoeAlexWongAlex Wong
📝 Text

SEARCH / FIND Formula for Text Manipulation

Find the position of text within a string. Copy-paste ready for Excel, Google Sheets, and Airtable.

=SEARCH("word",A1)
When you need this: When you have email addresses (A1) and need to find the position of @ symbol to extract the domain part.

How it works

  1. 1SEARCH finds the character position of a substring in text (case-insensitive).
  2. 2FIND is identical but case-sensitive.
  3. 3Returns 1 if found at start, 2 if at position 2, etc. Errors if not found.

Variations

Extract domain from email
=MID(A1,SEARCH("@",A1)+1,100)
Check if text contains substring
=IF(ISERROR(SEARCH("error",A1)),"Not Found","Found")

Related Formulas

CONCATENATE / TEXTJOIN — Join text from multiple cellsTextLEFT / RIGHT / MID — Extract part of a text stringTextLEN — Count the number of characters in textTextTRIM — Remove extra spaces from textText

Need a formula that's not here?

Generate custom formula →