Add an extension to a phone number
Turn (201) 555-0123 and 0012 into (201) 555-0123 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 | A8 | The phone number. | "(201) 555-0123" |
| 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. | "(201) 555-0123 ext. 0012" |
Read it left to right. A phone with no extension stays as it is. The numbers here are made-up.
=IF(A8="",IF(B8="","","Review extension without number"),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 their extensions into the green columns of the Template tab. The labels fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Paste extensions as text, so an extension like 0012 keeps its zeros.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Join a country code and a phone number
1 + 2015550123 → +12015550123
Get the template →
Mask all but the last four phone digits
2015550123 → ******0123
Get the template →
Create a phone-and-fax block
2015550123 + 2015550142 → Phone: 2015550123¶Fax: 2015550142
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →