Add a suffix after a comma
Turn Ava Reed and Jr. into Ava Reed, Jr. for formal letters.
What you'll make

The formula

| Number | Part | What it does | For row 8 |
|---|---|---|---|
| 1 | TRIM(A8)="" | Checks whether the name is empty. | Not empty |
| 2 | TRIM(A8) | The full name, without stray spaces. | "Ava Reed" |
| 3 | IF(TRIM(B8)…) | Adds a comma and the suffix, if there is one. | ", Jr." |
| 4 | IF( … ) | Leaves the row blank when there's no name. | "Ava Reed, Jr." |
The comma only appears when there is a suffix. No suffix, no comma.
=IF(TRIM(A8)="","",TRIM(A8)&IF(TRIM(B8)="","",", "&TRIM(B8)))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 full names and suffixes into the green columns of the Template tab. Leave the suffix empty when there isn't one.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Type suffixes without a comma, like Jr. not , Jr. Check that each one belongs to the right person.
Route: Get names ready for the letter
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Combine names with a middle initial
Ava + Marie + Reed → Ava M. Reed
Get the template →
Make Last, First with a middle initial
Ava + Marie + Reed → Reed, Ava M.
Get the template →
Make a first name and last initial
Ava + Reed → Ava R.
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →