Show a credential with its issuer

Turn RN and Lakeview Board into RN – Lakeview Board for reviewed letters.

What you'll make

In Excel: RN + Lakeview Board becomes RN – Lakeview Board.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8=""Checks if the issuer cell is empty.No
2"Review issuer"Shown when there is no issuer.Not used for row 8
3A8&" – "&B8Joins the credential and issuer with a dash."RN – Lakeview Board"
4IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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