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

In Excel: +12015550123 and 0012 becomes tel:+12015550123;ext=0012.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8=""Checks whether the phone cell is empty.No, it has a phone
2IF(B8="", … "Review …")Flags an extension that has no phone number.Not used for row 8
3"tel:"&A8Puts tel: in front of the phone."tel:+12015550123"
4IF(B8="","",";ext="&B8)Adds ;ext= and the extension, if there is one.";ext=0012"
5IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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