Write a tel: address with an extension
Turn +12015550123 and 0012 into tel:+12015550123;ext=0012. A lone extension is flagged.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks whether the phone cell is empty. | No, it has a phone |
| 2 | IF(B8="", … "Review …") | Flags an extension that has no phone number. | Not used for row 8 |
| 3 | "tel:"&A8 | Puts tel: in front of the phone. | "tel:+12015550123" |
| 4 | IF(B8="","",";ext="&B8) | Adds ;ext= and the extension, if there is one. | ";ext=0012" |
| 5 | IF( … ) | Uses part 2 when the phone is empty, otherwise parts 3 and 4. | "tel:+12015550123;ext=0012" |
Read it left to right. The result is plain text, not a clickable link. The numbers here are made-up.
=IF(A8="",IF(B8="","","Review extension without number"),"tel:"&A8&IF(B8="","",";ext="&B8))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 numbers. Paste phones (+ and digits only) and their extensions into the green columns of the Template tab. The tel: addresses fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Paste phones as + and digits only, like +12015550123. Spaces or dashes would end up in the address.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Write a phone number as (201) 555-0123
2015550123 → (201) 555-0123
Get the template →
Add the +1 code to a phone number
2015550123 → +12015550123
Get the template →
Add an extension to a phone number
(201) 555-0123 and 0012 → (201) 555-0123 ext. 0012
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →