Read the extension from a tel link

Turn tel:+12015550123;ext=0012 into 0012, zeros kept. No extension gives a blank.

What you'll make

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

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The tel link."tel:…;ext=0012"
2TEXTAFTER( … ,";ext=")Keeps the text after ;ext=."0012"
3IFERROR( … ,"")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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own links. Paste tel links into the green column of the Template tab. The extensions fill in by themselves.
  3. 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