Read the extension from a tel link
Turn tel:+12015550123;ext=0012 into 0012, zeros kept. No extension gives a blank.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The tel link. | "tel:…;ext=0012" |
| 2 | TEXTAFTER( … ,";ext=") | Keeps the text after ;ext=. | "0012" |
| 3 | IFERROR( … ,"") | Gives a blank when there is no extension. | "0012" |
Each bracket wraps the one before it, so Excel works from the inside out. The result is text, so 0012 keeps its zeros. The numbers here are made-up.
=IFERROR(TEXTAFTER(A8,";ext="),"")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 tel links into the green column of the Template tab. The extensions 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 ;ext= is written in lowercase and comes last. Anything after the extension comes back with it.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Replace a 00 dialing prefix with a plus
0012015550123 → +12015550123
Get the template →
Restore the lost zero in a phone number
2079460123, width 11 → 02079460123
Get the template →
Remove phone separators, keep the plus
(201) 555-0123 → 2015550123
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →