Keep a Canadian station with its box line
Turn box 4001 and STN A into PO BOX 4001 STN A, with the station as typed.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | "PO BOX " | The words PO BOX and a space. | "PO BOX " |
| 2 | A8 | Adds the box number exactly as typed. | "PO BOX 4001" |
| 3 | IF(B8="",…) | Adds a space and the station, if there is one. | "PO BOX 4001 STN A" |
Read it left to right. An empty station adds nothing, so there is no gap at the end.
="PO BOX "&A8&IF(B8="",""," "&B8)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 boxes. Paste box numbers and stations into the green columns of the Template tab. Leave the station empty when there isn't one.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Type the whole station, like STN A. The formula never adds STN or guesses a station from the city.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Place a UK post town above its postcode
London + SW1A 1AA → LONDON ¶ SW1A 1AA
Get the template →
Put a German postcode before the town
01067 + DRESDEN → 01067 DRESDEN
Get the template →
Place a unit before the civic number
Unit 5 + civic number 12 → 5-12 OAK ST
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →