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

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TRIM(A8)=TRIM(B8) | Checks whether the name is only the placeholder. | No match |
| 2 | TRIM(A8) | The name without stray spaces. | "Ava Reed" |
| 3 | IF( … ) | 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.
- See it work. The Example tab shows 20 made-up names with the formula already in.
- 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.
- 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
OTHER ROUTES YOU MIGHT LIKE

Remove all spaces from a single name
O’ Neill → O’Neill
Get the template →
Apply a known capitalization exception
van dijk + van Dijk → van Dijk
Get the template →
Replace narrow nonbreaking spaces
Ava [narrow no-break space] Reed → Ava Reed
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →