Remove the display hyphen from an EIN
Turn 01-2345678 into the nine digits 012345678. Leading zeros stay.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The EIN, with its hyphen. | "01-2345678" |
| 2 | "-" | What to find: the hyphen. | "-" |
| 3 | "" | What to put instead: nothing. | "" |
| 4 | SUBSTITUTE( … ) | Takes out every hyphen. | "012345678" |
The result is text, so the leading zero stays. The EINs here are made-up.
=SUBSTITUTE(A8,"-","")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 EINs into the green column of the Template tab. The digits fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only on EINs you have checked. In other IDs a hyphen can mean something.
Microsoft's help: SUBSTITUTE function
OTHER ROUTES YOU MIGHT LIKE

Remove spaces and hyphens from a TIN
01 - 2345678 → 012345678
Get the template →
Mask a text identifier except its final four
012345678 → XXXXX5678
Get the template →
Write a masked EIN with its hyphen
012345678 → **-***5678
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →