Swap an old email domain for a new one
Turn ava@old.test into ava@new.test. Other domains stay as they are.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | LOWER(TEXTAFTER(A8,"@"))=LOWER(B8) | Checks the domain is the old one, in any capitals. | TRUE |
| 2 | TEXTBEFORE(A8,"@") | Keeps the text before the @. | "ava" |
| 3 | &"@"&C8 | Adds the @ and the new domain. | "ava@new.test" |
| 4 | A8 | Any other email, left as it is. | Not used for row 8 |
| 5 | IF( … ) | Gives part 3 for the old domain, otherwise part 4. | "ava@new.test" |
Only an exact domain match changes, so mail.old.test stays.
=IF(LOWER(TEXTAFTER(A8,"@"))=LOWER(B8),TEXTBEFORE(A8,"@")&"@"&C8,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 emails, the old domain and the new domain into the green columns of the Template tab. The new emails fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only when you know the same mailbox exists at the new domain.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Restore at signs written as HTML codes
ava@example.com → [email protected]
Get the template →
Decode at signs and plus signs in emails
ava%2Bteam%40example.com → [email protected]
Get the template →
Get an email address from a mailto link
mailto:[email protected]?subject=Hello → [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 →