Insert the EIN hyphen preserving zeroes
Turn nine EIN digits like 012345678 into 01-2345678, zero kept.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | LEFT(A8,2) | Takes the first two digits. | "01" |
| 2 | &"-"& | Adds a hyphen after them. | "01-" |
| 3 | RIGHT(A8,7) | Adds the last seven digits. | "01-2345678" |
Read it left to right. The digits stay text, so a leading zero like the 0 in 012345678 stays. The EINs here are made-up.
=LEFT(A8,2)&"-"&RIGHT(A8,7)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 EIN digits, stored as text, into the green column of the Template tab. The EINs with hyphens 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 cells that hold all nine digits as text. A number that lost its zero comes out wrong.
Microsoft's help: LEFT function
OTHER ROUTES YOU MIGHT LIKE

Remove the display hyphen from an EIN
01-2345678 → 012345678
Get the template →
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 →
Keep the zero in a ZIP Code like 02108
2108 → 02108
Take this route →