Read an abbreviation in a credential label

Pull RN out of Registered Nurse (RN), so the short form has its own column.

What you'll make

In Excel: Registered Nurse (RN) becomes RN.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The full credential label."Registered Nurse (RN)"
2TEXTAFTER( … ,"(")Takes what comes after the opening bracket."RN)"
3TEXTBEFORE( … ,")")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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own labels. Paste full credential labels into the green column of the Template tab. The abbreviations fill in by themselves.
  3. 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