Formula guide · Excel and Google Sheets · Updated May 13, 2026
Extract Domain from Email Address
Extract the domain name after the @ symbol from an email address in Excel or Google Sheets.
Quick Answer
Use TEXTAFTER in modern Excel, or SPLIT in Google Sheets, to return the part after @.
Copyable Formula
=TEXTAFTER(A2,"@")Syntax
=TEXTAFTER(A2,"@")Excel and Google Sheets
Worked Example
| A | B |
|---|---|
| Domain | |
| maya@acme.com | acme.com |
| lee@north.co | north.co |
Result: Returns the email domain so rows can be grouped or checked by company.
Steps
- Clean spaces from the email address first.
- Use TEXTAFTER to return text after @ in Excel.
- Use INDEX(SPLIT(A2,"@"),2) in Google Sheets if preferred.
- Check invalid emails before using the result in reports.
Common Mistakes
- Not removing spaces before extracting the domain.
- Assuming every row contains a valid @ symbol.
- Lowercasing too late when domains have inconsistent capitalization.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.