Write an address as a single sentence
Turn four address cells into 12 OAK ST, BOSTON, MA 02108 for a letter.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The street line, with any unit. | "12 OAK ST" |
| 2 | B8 | Adds a comma, a space and the city. | "12 OAK ST, BOSTON" |
| 3 | C8 | Adds a comma, a space and the state. | "…, BOSTON, MA" |
| 4 | D8 | Adds a space and the ZIP code. | "…, BOSTON, MA 02108" |
Read it left to right. The commas and spaces between the parts are joined in with &.
=A8&", "&B8&", "&C8&" "&D8How 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 street lines, cities, states and ZIP codes into the green columns of the Template tab. The sentences fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This is for the letter's text. Keep the usual layout on the envelope.
Microsoft's help: Combine text from two or more cells
OTHER ROUTES YOU MIGHT LIKE

Build a PO Box delivery line
123 → PO BOX 123
Get the template →
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 →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →