Text
Basic Email Validation
Validate whether a text string follows basic email format rules (contains @, has text before and after @, has a dot after @). Not a full RFC validation but catches most formatting errors.
Excel Formula
=AND(ISERROR(FIND(" ",A2)),LEN(A2)-LEN(SUBSTITUTE(A2,"@",""))=1,FIND("@",A2)>1,FIND(".",A2,FIND("@",A2))>FIND("@",A2)+1)Google Sheets Version
=REGEXMATCH(A2,"^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$")Step-by-Step Explanation
1
Checks that there are no spaces in the email
2
Verifies exactly one @ symbol exists
3
Ensures @ is not the first character
4
Confirms a dot exists after the @ symbol
5
Returns TRUE for valid format, FALSE for invalid
Example
| Email (A) | Valid? (B) |
|---|---|
| john@example.com | TRUE |
| invalid@ | FALSE |
| no spaces@email.com | FALSE |
| @nodomain.com | FALSE |
Result: Formula → TRUE for valid emails, FALSE for invalid
Common Variations
Sheets regex
=REGEXMATCH(A2,"^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$")More thorough validation
Highlight invalid
Use Conditional Formatting with the validation formulaRed highlight on invalid emails
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →