Build a PO Box delivery line
Turn a confirmed box number like 123 into PO BOX 123 for mailing labels.
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 123" |
Read it left to right. The box number is kept as text, so leading zeros stay.
="PO BOX "&A8How 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 box numbers. Paste confirmed box numbers into the green column of the Template tab. The delivery lines fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Paste only confirmed box numbers. The formula doesn't turn a street address into a PO Box.
Microsoft's help: Combine text from two or more cells
OTHER ROUTES YOU MIGHT LIKE

Build a rural-route and box line
Route 2 plus box 145 → RR 2 BOX 145
Get the template →
Build a military or diplomatic last line
APO + AE + 09021 → APO AE 09021
Get the template →
Build a Canadian address line
Ottawa + ON + K1A 0B1 → OTTAWA ON K1A 0B1
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →