# How To Get The Domain From An Email Address

## Example

=RIGHT(B3,LEN(B3)-FIND(“@”,B3))

## Generic Formula

=RIGHT(Email,LEN(Email)-FIND(“@”,Email))

Email – This is the email address from which you’d like to extract the domain from.

## What It Does

This formula will return the domain from a given email address. For example the domain of “yourname@yourcompany.com” would be “yourcompany.com”.

## How It Works

LEN(Email) will give us the total character count of the email address. In our example LEN(“jim.smith@breadmakers.com”) returns 25 since there are 25 characters in this email address.

FIND(“@”,Email) will return the location of the “@” character in the email address. In our example FIND(“@”,”jim.smith@breadmakers.com”) returns 10 since the “@” symbol is the 10th character in the email address.

The difference between these two will then give us the total character count of all the characters after the “@” symbol. This is the total character count of the domain (let’s call this N). In our example this is 25-10 = 15. We see that “breadmakers.com” does in fact have 15 characters in it.

We can now use RIGHT(Email,DomainCount) to extract the N right most characters from the email address which will be our domain. In our example this is RIGHT(“jim.smith@breadmakers.com”,15) which returns “breadmakers.com”.

### John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

### Subscribe

Subscribe for awesome Microsoft Excel videos ðŸ˜ƒ

## Related Posts

#### 8 Ways to Apply a Formula to an Entire Column in Microsoft Excel

Are you wondering how to apply a formula to an entire column in Excel? Read...

#### 5 Ways to Lock and Unlock Formulas in Microsoft Excel

Do you want to lock the formulas in your Excel sheet to prevent other users...

#### 9 Ways to Show Formulas in Microsoft Excel

This post is going to show you all the different ways you can show the...