Get an email address from a mailto link
Turn mailto:ava@example.com?subject=Hello into ava@example.com.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | LEFT(LOWER(TRIM(A8)),7)="mailto:" | Checks if the cell starts with mailto:, in any capitals. | TRUE |
| 2 | MID(TRIM(A8),8,999)&"?" | Drops mailto: and adds a ? at the end. | "ava@example.com?…" |
| 3 | TEXTBEFORE( … ,"?") | Keeps the text before the first ?. | "ava@example.com" |
| 4 | TRIM(A8) | A plain address, with extra spaces removed. | Not used for row 8 |
| 5 | IF( … ) | Gives part 3 for a mailto link, otherwise part 4. | "ava@example.com" |
Parts 2 and 3 work from the inside out. The added ? covers links with no ?.
=IF(LEFT(LOWER(TRIM(A8)),7)="mailto:",TEXTBEFORE(MID(TRIM(A8),8,999)&"?","?"),TRIM(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 links. Paste mailto links or addresses into the green column of the Template tab. The addresses fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Check links with several addresses or a name in them. Only one plain address comes out right.
Microsoft's help: TEXTBEFORE function
OTHER ROUTES YOU MIGHT LIKE

Read an address from Name <address>
Ava Reed <[email protected]> → [email protected]
Get the template →
Remove spaces from an email address
ava @ example.com → [email protected]
Get the template →
Lowercase only the email domain
[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 →