Fix odd hyphens in house numbers
Turn a look-alike dash in 108‑02 into an ordinary hyphen. Leading zeros stay.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The house number. ‑ and – only look like hyphens. | "108‑02" |
| 2 | SUBSTITUTE( … 8209 … ) | Swaps the nonbreaking hyphen ‑ for an ordinary one. | "108-02" |
| 3 | SUBSTITUTE( … 8211 … ) | Swaps the short dash – for an ordinary hyphen. | "108-02" |
The outer bracket wraps the inner one, so Excel works from the inside out.
=SUBSTITUTE(SUBSTITUTE(A8,UNICHAR(8209),"-"),UNICHAR(8211),"-")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 addresses. Paste house numbers into the green column of the Template tab. Fixed numbers 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 house numbers. A dash in a range like 10–20 may mean something else.
Microsoft's help: SUBSTITUTE function
OTHER ROUTES YOU MIGHT LIKE

Get a house number with a fraction
12 1/2 Oak St → 12 1/2
Get the template →
Return the street after a fraction
12 1/2 Oak St → Oak St
Get the template →
Read the street from a grid address
820 W 400 N → 400
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →