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

In Excel: Box 4001 plus STN A becomes PO BOX 4001 STN A.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1"PO BOX "The words PO BOX and a space."PO BOX "
2A8Adds the box number exactly as typed."PO BOX 4001"
3IF(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.

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