Collapse two copies of a known name
Turn Ava Reed Ava Reed into Ava Reed when you know the name.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TRIM(A8)=TRIM(B8)&" "&TRIM(B8) | Checks whether the cell is the name typed twice. | Match |
| 2 | TRIM(B8) | If it is, the expected name once. | "Ava Reed" |
| 3 | TRIM(A8) | Otherwise the cell, without stray spaces. | Not used for row 8 |
| 4 | IF( … ) | Picks the right result for the row. | "Ava Reed" |
Read it left to right. Capitals and extra spaces don't matter in part 1, so ava reed ava reed matches too.
=IF(TRIM(A8)=TRIM(B8)&" "&TRIM(B8),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 the name text into column A of the Template tab and the name you expect into column B. 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 an exact double gets fixed. Ava Reed A. Reed stays as it is, so check those by hand.
Route: Get names ready for the letter
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Remove a repeated surname at the end
Ava Reed Reed + surname Reed → Ava Reed
Get the template →
Uppercase only the first letter
o’Neill → O’Neill
Get the template →
Remove extra spaces from names
" Ava Reed " → Ava Reed
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →