Restore at signs written as HTML codes
Turn ava@example.com from a web export back into ava@example.com.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The email from the export. | "ava@…" |
| 2 | SUBSTITUTE( … @ … ) | Turns the code @ into @. | "ava@example.com" |
| 3 | SUBSTITUTE( … @ … ) | Turns the code @ into @ too. | "ava@example.com" |
Each bracket wraps the one before it, so Excel works from the inside out. The addresses here are made-up.
=SUBSTITUTE(SUBSTITUTE(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 exported emails into the green column of the Template tab. The fixed addresses fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Only @ and lowercase @ are changed. Look for any & left in the results and fix those by hand.
Microsoft's help: SUBSTITUTE function
OTHER ROUTES YOU MIGHT LIKE

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 →
Read an address from Name <address>
Ava Reed <[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 →