Put a German postcode before the town
Turn 01067 and DRESDEN into 01067 DRESDEN, keeping the zero.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | Takes the five-digit postcode, leading zero and all. | "01067" |
| 2 | &" "& | Adds a space. | "01067 " |
| 3 | B8 | Adds the town. | "01067 DRESDEN" |
Read it left to right. The pieces are joined together with &.
=A8&" "&B8How 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 checked postcodes and towns into the green columns of the Template tab. Don't add D- in front of the postcode.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
If a postcode already shows 1067, fix it to 01067 first. The formula can't bring a lost zero back.
Microsoft's help: Combine text from two or more cells
OTHER ROUTES YOU MIGHT LIKE

Place a unit before the civic number
Unit 5 + civic number 12 → 5-12 OAK ST
Get the template →
Keep a Canadian station with its box line
Box 4001 plus STN A → PO BOX 4001 STN A
Get the template →
Place a UK post town above its postcode
London + SW1A 1AA → LONDON ¶ SW1A 1AA
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →