Mask all but the last four phone digits
Turn 2015550123 into ******0123 for a short display label.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks if the phone cell is empty. | No |
| 2 | REPT("*",MAX(0,LEN(A8)-4)) | Writes one * for each digit before the last four. | "******" |
| 3 | RIGHT(A8,4) | Adds the last four digits as they are. | "******0123" |
| 4 | IF( … ) | Leaves empty rows blank, otherwise uses parts 2 and 3. | "******0123" |
MAX stops the count going below zero. The original cell doesn't change. The numbers here are made-up.
=IF(A8="","",REPT("*",MAX(0,LEN(A8)-4))&RIGHT(A8,4))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 phone numbers, digits only, into the green column of the Template tab. The masked labels fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Paste digits only, with no spaces, + or extension. Keep the full numbers safe; this is only a label.
Microsoft's help: REPT function
OTHER ROUTES YOU MIGHT LIKE

Create a phone-and-fax block
2015550123 + 2015550142 → Phone: 2015550123¶Fax: 2015550142
Get the template →
Write a tel: address with an extension
+12015550123 and 0012 → tel:+12015550123;ext=0012
Get the template →
Write a phone number as (201) 555-0123
2015550123 → (201) 555-0123
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →