Put a German postcode before the town

Turn 01067 and DRESDEN into 01067 DRESDEN, keeping the zero.

What you'll make

In Excel: 01067 + DRESDEN becomes 01067 DRESDEN.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8Takes the five-digit postcode, leading zero and all."01067"
2&" "&Adds a space."01067 "
3B8Adds the town."01067 DRESDEN"

Read it left to right. The pieces are joined together with &.

=A8&" "&B8

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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.