Lowercase only the email domain
Turn Ava.Reed@EXAMPLE.COM into Ava.Reed@example.com. The rest stays.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXTBEFORE(A8,"@") | Keeps the text before the @, capitals as typed. | "Ava.Reed" |
| 2 | &"@"& | Puts the @ back between the two halves. | "Ava.Reed@" |
| 3 | TEXTAFTER(A8,"@") | Takes the text after the @. | "EXAMPLE.COM" |
| 4 | LOWER( … ) | Turns only that text into small letters. | "Ava.Reed@example.com" |
Part 4 changes only part 3's text, so the name before the @ keeps its capitals.
=TEXTBEFORE(A8,"@")&"@"&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 emails into the green column of the Template tab. The fixed emails fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This only changes capitals after the @. It doesn't check that the address works.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Remove an end semicolon from an email
[email protected]; → [email protected]
Get the template →
Swap an old email domain for a new one
[email protected] → [email protected]
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 →