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

In Excel: Route 2 plus box 145 becomes RR 2 BOX 145.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1"RR "Starts the line with RR and a space."RR "
2A8Adds the route number."RR 2"
3" BOX "Adds a space, the word BOX and a space."RR 2 BOX "
4B8Adds the box number."RR 2 BOX 145"

Read it left to right. The pieces are joined together with &.

="RR "&A8&" BOX "&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 addresses. Paste route numbers and box numbers into the green columns of the Template tab. The delivery lines fill in by themselves.
  3. 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.