Lowercase only the email domain

Turn Ava.Reed@EXAMPLE.COM into Ava.Reed@example.com. The rest stays.

What you'll make

In Excel: Ava.Reed@EXAMPLE.COM becomes Ava.Reed@example.com.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1TEXTBEFORE(A8,"@")Keeps the text before the @, capitals as typed."Ava.Reed"
2&"@"&Puts the @ back between the two halves."Ava.Reed@"
3TEXTAFTER(A8,"@")Takes the text after the @."EXAMPLE.COM"
4LOWER( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own list. Paste emails into the green column of the Template tab. The fixed emails fill in by themselves.
  3. 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