Read a lowercase email domain
Turn ava@EXAMPLE.COM into example.com, with any subdomain kept.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The email address. | "ava@EXAMPLE.COM" |
| 2 | TEXTAFTER( … ,"@") | Keeps the text after the @ sign. | "EXAMPLE.COM" |
| 3 | LOWER( … ) | Turns the domain into small letters. | "example.com" |
Each bracket wraps the one above it, so Excel works from the inside out.
=LOWER(TEXTAFTER(A8,"@"))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 domains fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This shows the whole domain after the @, subdomain included. It doesn't check the address works.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Read the last part of an email domain
[email protected] → org
Get the template →
Get the email part before the at sign
[email protected] → Ava.Reed+team
Get the template →
Remove an end semicolon from an email
[email protected]; → [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 →