
Build a U.S. city-state-ZIP line
Boston + MA + 02108 → BOSTON MA 02108
66 free Excel templates to clean up addresses and get them ready for the envelope. For example, 123 becomes PO BOX 123. Pick the one that matches your list, download it and paste your data in. No sign-up, no macros.
66 templates

Boston + MA + 02108 → BOSTON MA 02108

12 OAK ST + APT 5 → 12 OAK ST APT 5

Street, city, state, ZIP → 12 OAK ST, BOSTON, MA 02108

123 → PO BOX 123

Route 2 plus box 145 → RR 2 BOX 145

APO + AE + 09021 → APO AE 09021

Ottawa + ON + K1A 0B1 → OTTAWA ON K1A 0B1

Northeast in its own direction field → NE

12 Oak St + 12 Oak St → line 2 blank

12 Oak St [Windows break] Boston → 12 Oak St ¶ Boston

12 Oak St\nBoston, MA 02108 → two address lines

12 Oak St<br>Boston, MA 02108 → two address lines

2108 → text 02108

21081234 → 02108-1234

02108 + 1234 → 02108-1234

02108-1234 → text 02108

02108-1234 → 1234; ZIP alone → blank

021081234 → 02108-1234

2108 → 02108; 01002-4410 stays as it is

02108 → text 021

21081234 → text 02108

US-02108 → 02108; CA-K1A 0B1 → Review country prefix

2108 → 02108; 106103 → Review ZIP

02108 + 02108-1234 → 02108-1234

sw1a1aa → SW1A 1AA

k1a0b1 → K1A 0B1

021081234 + US → 02108-1234; k1a0b1 + CA → K1A 0B1

Unit 5 + civic number 12 → 5-12 OAK ST

Box 4001 plus STN A → PO BOX 4001 STN A

London + SW1A 1AA → LONDON ¶ SW1A 1AA

01067 + DRESDEN → 01067 DRESDEN

US + 02108 → US|02108; CA + m5v 2t6 → CA|M5V2T6

021081234 + 5 + - → 02108-1234

1002 + 0 → 01002-0000

Ava Reed or ATTN Ava Reed → ATTN Ava Reed

ATTN Ava Reed ¶ 12 Oak St → Ava Reed

Acme Co. | MAILSTOP: 4B-210 → 4B-210

Acme Co. | MAILSTOP: 4B-210 → Acme Co.

A + 02 + 004B → BLDG A FL 02 RM 004B

APT + APT 5 → 5

12 Oak St #5 + APT → 12 Oak St APT 5

12 Oak St #5 → 12 Oak St # 5

12 Oak St APT 5 + APT → 5

12 Oak St APT 5 + APT → 12 Oak St

STE 200 + 45 → 12 Oak St STE 200 PMB 45

Postal box + 123 → PO BOX 123

#8 PMB 112 → Facility secondary: #8; customer PMB: 112

Boston MA 02108-1234 + 15 → Boston MA ¶ 02108-1234

Acme Office Supply Company + 20 → Acme Office Supply ¶ Company

6-line label, 3 address + 1 program → 2 lines left

Centerline Medical Center + Center, Ctr → Centerline Medical Ctr

12 Oak St ¶ NULL ¶ Boston → 12 Oak St ¶ Boston

12 Oak ¶ St ¶ Boston + break 1 → 12 Oak St ¶ Boston

12 Oak St ¶ ¶ Boston, MA 02108 + 3 → Boston, MA 02108

12 COURT STREET + STREET, ST → 12 COURT ST

108‑02 → 108-02

12 1/2 Oak St → 12 1/2

12 1/2 Oak St → Oak St

820 W 400 N → 400

N + 89 + W + 16786 → N89W16786

12, A, Letter → 12A

PRINCIPALE + RUE + French → RUE PRINCIPALE

STAR ROUTE + 007 + 001-02 → HC 7 BOX 001-02

HC 1 BOX 120 → 02108-4410 (box range, not route)

AAN1 + 2 → N1

12 Oak St&Oak St&12 → 12 Oak St