Label pre-admission and encounter IDs

A pre-registration number isn't a visit ID. Label each one so they stay apart.

What you'll make

In Excel: P451 + V208 becomes Pre-admission ID: P451; encounter ID: V208.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1IF(A8="", … ,"Pre-admission ID: "&A8)Labels the pre-admission ID, or says not supplied."… ID: P451"
2&"; "&Adds a semicolon and a space."… P451; "
3IF(B8="", … ,"encounter ID: "&B8)Labels the encounter ID, or says not supplied."… ID: V208"

Read it left to right. Each ID is kept exactly as typed, leading zeros included. The IDs here are made-up.

=IF(A8="","Pre-admission ID not supplied","Pre-admission ID: "&A8)&"; "&IF(B8="","encounter ID not supplied","encounter ID: "&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 list. Paste each pre-admission ID and encounter ID into the green columns of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Matching numbers don't prove two IDs are the same. Check the source system before merging them.

Microsoft's help: IF function