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

In Excel: Street, city, state, ZIP becomes 12 OAK ST, BOSTON, MA 02108.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The street line, with any unit."12 OAK ST"
2B8Adds a comma, a space and the city."12 OAK ST, BOSTON"
3C8Adds a comma, a space and the state."…, BOSTON, MA"
4D8Adds 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&" "&D8

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 street lines, cities, states and ZIP codes into the green columns of the Template tab. The sentences fill in by themselves.
  3. 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.