Read a mailstop from a company field
Turn Acme Co. | MAILSTOP: 4B-210 into 4B-210, kept as text.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXTAFTER(A8," | MAILSTOP: ") | Keeps the text after the | MAILSTOP: label. | "4B-210" |
| 2 | "Review mailstop label" | What the cell says when the label is missing. | Not used for row 8 |
| 3 | IFERROR( … ) | Uses part 2 when there is no MAILSTOP label. | "4B-210" |
The label must match exactly, spaces and capitals included.
=IFERROR(TEXTAFTER(A8," | MAILSTOP: "),"Review mailstop label")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 company fields into the green column of the Template tab. The mailstops fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Only the exact label | MAILSTOP: is read. Fix Mailstop: or MS by hand first.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Recover the firm from a mailstop field
Acme Co. | MAILSTOP: 4B-210 → Acme Co.
Get the template →
Add one ATTN prefix without doubling it
Ava Reed or ATTN Ava Reed → ATTN Ava Reed
Get the template →
Extract attention text from an ATTN line
ATTN Ava Reed ¶ 12 Oak St → Ava Reed
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →