Write an NPI-ending caption

Turn the NPI 1234567890 into NPI ending 7890 for a letter or notice.

What you'll make

In Excel: 1234567890 becomes NPI ending 7890.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1"NPI ending "The words in front, with a space."NPI ending "
2RIGHT(A8,4)Adds the last four digits of the NPI."NPI ending 7890"

Read it left to right. The & joins the two pieces. The NPIs here are made-up.

="NPI ending "&RIGHT(A8,4)

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 IDs. Paste ten-digit NPIs into the green column of the Template tab. The captions fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Four digits can't identify a provider on their own. Follow your letter's rules for what else to show.

Microsoft's help: RIGHT function