Show a credential with its issuer
Turn RN and Lakeview Board into RN – Lakeview Board for reviewed letters.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | B8="" | Checks if the issuer cell is empty. | No |
| 2 | "Review issuer" | Shown when there is no issuer. | Not used for row 8 |
| 3 | A8&" – "&B8 | Joins the credential and issuer with a dash. | "RN – Lakeview Board" |
| 4 | IF( … ) | Uses part 2 if part 1 says yes, else part 3. | "RN – Lakeview Board" |
Read it left to right. The issuer names here are made-up.
=IF(B8="","Review issuer",A8&" – "&B8)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 credentials. Paste each credential and its reviewed issuer into the green columns of the Template tab. The displays fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Showing an issuer doesn't prove the credential. Only paste issuers someone has checked.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Add a retired label to a credential
RN + Retired → RN (retired)
Get the template →
Show a credential only when verified
RN + Verified → RN
Get the template →
Build a credential and license display
RN + NY + 00012345 → RN (NY 00012345)
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →