Build a rural-route and box line
Turn route 2 and box 145 into RR 2 BOX 145 for mailing labels.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | "RR " | Starts the line with RR and a space. | "RR " |
| 2 | A8 | Adds the route number. | "RR 2" |
| 3 | " BOX " | Adds a space, the word BOX and a space. | "RR 2 BOX " |
| 4 | B8 | Adds the box number. | "RR 2 BOX 145" |
Read it left to right. The pieces are joined together with &.
="RR "&A8&" BOX "&B8How 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 route numbers and box numbers into the green columns 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
Type only the numbers. The formula adds RR and BOX for you.
Microsoft's help: Combine text from two or more cells
OTHER ROUTES YOU MIGHT LIKE

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 →
Build a U.S. city-state-ZIP line
Boston + MA + 02108 → BOSTON MA 02108
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →