Read the last part of an email domain
Turn ava@dept.example.org into org. It doesn't tell you a country.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The email address. | "ava@dept.example.org" |
| 2 | TEXTAFTER( … ,"@") | Keeps the text after the @ sign. | "dept.example.org" |
| 3 | TEXTAFTER( … ,".",-1) | Keeps the text after the last dot. | "org" |
Each bracket wraps the one above it, so Excel works from the inside out.
=TEXTAFTER(TEXTAFTER(A8,"@"),".",-1)How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own list. Paste email addresses into the green column of the Template tab. The last parts fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This is only the text after the last dot. It doesn't tell you the country or the organization.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Get the email part before the at sign
[email protected] → Ava.Reed+team
Get the template →
Read a lowercase email domain
[email protected] → example.com
Get the template →
Restore at signs written as HTML codes
ava@example.com → [email protected]
Get the template →
Check each email went to the right address, once
Your list of 2 → 2 sent copies, each to the right address
Take this route →