Wrap a firm name at the last space
Acme Office Supply Company is too long for 20 characters, so Company moves down.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | LEN(A8)<=B8 | Checks the whole name fits the limit in column B. | No |
| 2 | TEXTBEFORE(LEFT(A8,B8+1)," ",-1) | Keeps the words before the last space that fits. | "Acme Office Supply" |
| 3 | MID(A8, … ,LEN(A8)) | Keeps every word after that space. | "Company" |
| 4 | IFERROR( … ) | Says Review when no space fits the limit. | "Acme Office…¶Company" |
| 5 | IF( … ) | Keeps a name that fits, otherwise uses part 4. | "Acme Office…¶Company" |
CHAR(10) between parts 2 and 3 starts a new line. ¶ marks a line break.
=IF(LEN(A8)<=B8,A8,IFERROR(TEXTBEFORE(LEFT(A8,B8+1)," ",-1)&CHAR(10)&MID(A8,LEN(TEXTBEFORE(LEFT(A8,B8+1)," ",-1))+2,LEN(A8)),"Review no safe firm-name word break"))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 names and the longest first line allowed into the green columns of the Template tab. The wrapped names fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Only the first line is checked. Make sure the second line fits too, and turn on Wrap Text where you paste.
Microsoft's help: TEXTBEFORE function
OTHER ROUTES YOU MIGHT LIKE

Calculate remaining label lines
6-line label, 3 address + 1 program → 2 lines left
Get the template →
Abbreviate one whole business word
Centerline Medical Center + Center, Ctr → Centerline Medical Ctr
Get the template →
Move the ZIP to a new line when too long
Boston MA 02108-1234 + 15 → Boston MA ¶ 02108-1234
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →