Abbreviate one whole business word
Turn Center into Ctr only where it stands alone, so Centerline stays as it is.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | " "&A8&" " | The firm line with a space added at each end. | " Centerline … Center " |
| 2 | " "&B8&" " | The word, with spaces, so only whole words match. | " Center " |
| 3 | " "&C8&" " | The short form, with spaces kept. | " Ctr " |
| 4 | SUBSTITUTE( … ) | Swaps the whole word for the short form. | " Centerline … Ctr " |
| 5 | TRIM( … ) | Removes the added spaces at the ends. | "Centerline Medical Ctr" |
Each bracket wraps the one above it, so Excel works from the inside out. Capitals must match.
=TRIM(SUBSTITUTE(" "&A8&" "," "&B8&" "," "&C8&" "))How 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 firm lines, the word to shorten and its short form into the green columns of the Template tab. The shortened lines fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Keep the full word when the line already fits. A word next to a comma or period is left as it is.
Microsoft's help: SUBSTITUTE function
OTHER ROUTES YOU MIGHT LIKE

Move the ZIP to a new line when too long
Boston MA 02108-1234 + 15 → Boston MA ¶ 02108-1234
Get the template →
Wrap a firm name at the last space
Acme Office Supply Company + 20 → Acme Office Supply ¶ Company
Get the template →
Calculate remaining label lines
6-line label, 3 address + 1 program → 2 lines left
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →