Label a box or mailstop number by role
The role column decides the label: PO BOX, PMB or MSC. Nothing is guessed.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | Reads the delivery role for this row. | "Postal box" |
| 2 | "Postal box","PO BOX "&B8 | A postal box gets PO BOX before the number. | "PO BOX 123" |
| 3 | "Private mailbox","PMB "&B8 | A private mailbox gets PMB before the number. | Not used for row 8 |
| 4 | "Mailstop","MSC "&B8 | A mailstop inside a company gets MSC. | Not used for row 8 |
| 5 | SWITCH( … ) | Uses the part that matches the role. | "PO BOX 123" |
Read it left to right. Any other role says Review box/mailstop role.
=SWITCH(A8,"Postal box","PO BOX "&B8,"Private mailbox","PMB "&B8,"Mailstop","MSC "&B8,"Review box/mailstop role")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 addresses. Paste each role (Postal box, Private mailbox or Mailstop) and its number into the green columns of the Template tab. The box lines fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Take each role from your records; never guess it from the number. Then add the rest of the address.
Microsoft's help: SWITCH function
OTHER ROUTES YOU MIGHT LIKE

Keep both parts of a suite and PMB field
#8 PMB 112 → Facility secondary: #8; customer PMB: 112
Get the template →
Join building, floor and room codes
A + 02 + 004B → BLDG A FL 02 RM 004B
Get the template →
Remove a duplicated unit designator
APT + APT 5 → 5
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →