Read the extension from a ZIP+4
Turn 02108-1234 into the four-digit 1234. A ZIP alone stays blank.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | LEN(A8)=10 | Checks the cell is ten characters, a full ZIP+4. | Yes |
| 2 | RIGHT(A8,4) | Keeps the last four characters. | "1234" |
| 3 | IF( … ) | Uses part 2, or stays blank for a ZIP alone. | "1234" |
The result is text, so zeros like the 00 in 0021 stay. No extension never becomes 0000.
=IF(LEN(A8)=10,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 addresses. Paste ZIPs or ZIP+4s into the green column of the Template tab. The extensions 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, like 02108 or 02108-1234. Other ten-character codes aren't checked.
Microsoft's help: RIGHT function
OTHER ROUTES YOU MIGHT LIKE

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 →
Read a three-character ZIP prefix
02108 → text 021
Get the template →
Keep the zero in a ZIP Code like 02108
2108 → 02108
Take this route →