Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to validate email address format in Excel and Google Sheets
Heads up: Excel and Google Sheets do this differently.
Excel
=IF(AND(ISNUMBER(SEARCH("@",A2)),ISNUMBER(SEARCH(",",SUBSTITUTE(A2,"@","",1)))),TRUE,FALSE)Google Sheets
=REGEXMATCH(A2,"^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$")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
Step by step
- 1In Excel, use the formula provided to check if the cell contains a valid email format.
- 2In Google Sheets, use the REGEXMATCH function with a regular expression to validate the email format.
- 3Apply the formula to each cell containing an email address by dragging the fill handle.
Tips
- Ensure your email addresses do not contain spaces or special characters outside the standard format.
- Regular expressions can be complex; test them with sample data to ensure they work as expected.
- Excel's formula checks for the presence of '@' and '.', while Google Sheets uses a more robust regex pattern.
Need the Google Sheets version instead? Open Sheets variant in workspace →
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What if my email addresses have subdomains?
The provided Google Sheets formula supports subdomains. The Excel formula may need adjustment.
Can I validate multiple email addresses at once?
Yes, apply the formula to a range of cells and drag the fill handle to validate all at once.
Why does Excel's formula return FALSE for some valid emails?
Excel's formula is simplified and may not cover all valid email formats. Consider using a more comprehensive regex in Google Sheets.