Read the five-digit ZIP from a ZIP+4
Turn a confirmed ZIP+4 like 02108-1234 into the text 02108.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The ZIP or ZIP+4, stored as text. | "02108-1234" |
| 2 | 5 | How many characters to keep. | 5 |
| 3 | LEFT( … ) | Keeps the first five characters. | "02108" |
The result is text, so leading zeros like the 0 in 02108 stay.
=LEFT(A8,5)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 ZIPs or ZIP+4s into the green column of the Template tab. The five-digit ZIPs 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 ZIPs stored as text in a known format. It doesn't fix short, damaged or foreign codes.
Microsoft's help: LEFT function
OTHER ROUTES YOU MIGHT LIKE

Read the extension from a ZIP+4
02108-1234 → 1234; ZIP alone → blank
Get the template →
Insert ZIP+4 grouping into nine-digit text
021081234 → 02108-1234
Get the template →
Keep number and text ZIPs as text
2108 → 02108; 01002-4410 stays as it is
Get the template →
Keep the zero in a ZIP Code like 02108
2108 → 02108
Take this route →