Read an abbreviation in a credential label
Pull RN out of Registered Nurse (RN), so the short form has its own column.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The full credential label. | "Registered Nurse (RN)" |
| 2 | TEXTAFTER( … ,"(") | Takes what comes after the opening bracket. | "RN)" |
| 3 | TEXTBEFORE( … ,")") | Keeps what comes before the closing bracket. | "RN" |
Each bracket wraps the one above it, so Excel works from the inside out.
=TEXTBEFORE(TEXTAFTER(A8,"("),")")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 labels. Paste full credential labels into the green column of the Template tab. The abbreviations 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 pair of brackets is read. Check labels with no brackets or two pairs by hand.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Keep the first credential in a list
BSN, RN → BSN
Get the template →
Remove one credential from a list
BSN, RN, LPN minus LPN → BSN, RN
Get the template →
Count credentials in a list
BSN, RN → 2 credentials
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →