FormulaGenius
Text

Extract Domain from Email

Extract the domain name (e.g., gmail.com) from an email address. Useful for analyzing email lists, segmenting contacts by company, or data cleaning.

Excel Formula

=RIGHT(A2, LEN(A2)-FIND("@", A2))

Step-by-Step Explanation

1

FIND("@", A2) locates the position of the @ symbol

2

LEN(A2) gets the total length of the email

3

LEN(A2)-FIND("@", A2) calculates characters after @

4

RIGHT extracts that many characters from the end

5

Result is everything after the @ symbol

Example

Email (A)Domain (B)
john@acme.comacme.com
sarah@google.comgoogle.com
info@nipper.digitalnipper.digital

Result: =RIGHT(A2,LEN(A2)-FIND("@",A2)) → acme.com

Common Variations

Username only

=LEFT(A2,FIND("@",A2)-1)

Extract part before @

Top-level domain

=RIGHT(A2,LEN(A2)-FIND(".",A2,FIND("@",A2)))

Just .com, .org, etc.

Need a Custom Version?

Use our AI generator to create a formula tailored to your specific data and requirements.

Try It with AI →

Related Templates

Text

Basic Email Validation

Check if a text string is a valid email format

Text

Clean Phone Numbers

Remove formatting from phone numbers leaving only digits

Text

Split Full Name into First/Last

Separate a full name into first name and last name