Replace a name placeholder with a blank

Turn N/A into an empty cell and keep real names as they are.

What you'll make

In Excel: N/A + N/A becomes blank.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1TRIM(A8)=TRIM(B8)Checks whether the name is only the placeholder.No match
2TRIM(A8)The name without stray spaces."Ava Reed"
3IF( … )Blank for the placeholder, otherwise the name."Ava Reed"

Read it left to right. Capitals don't matter in part 1, so n/a matches N/A.

=IF(TRIM(A8)=TRIM(B8),"",TRIM(A8))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up names with the formula already in.
  2. Use your own names. Paste names into column A and the placeholder, such as N/A, into column B of the Template tab. Clean names fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Only a cell that is exactly the placeholder turns blank. Ava Reed N/A keeps its N/A, so fix those by hand.

Route: Get names ready for the letter

Microsoft's help: IF function