Write a masked EIN with its hyphen
Turn the EIN 012345678 into **-***5678, showing only the last four digits.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | "**-***" | Stars for the hidden digits, with the hyphen. | "**-***" |
| 2 | RIGHT(A8,4) | Adds the last four digits of the EIN. | "**-***5678" |
Read it left to right. The & joins the two pieces. The EINs here are made-up.
="**-***"&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 IDs. Paste nine-digit EINs into the green column of the Template tab. The masked EINs fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This only hides digits in the new column. The full EINs are still in the green column, so remove them before you share the file.
Microsoft's help: RIGHT function
OTHER ROUTES YOU MIGHT LIKE

Write an NPI-ending caption
1234567890 → NPI ending 7890
Get the template →
Build a labeled NPI and TIN line
1234567890 + 012345678 → NPI: 1234567890 | TIN: 012345678
Get the template →
Keep only IDs of an approved type
NPI + 1234567890 → 1234567890 (approved type)
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →