Make a Last, F. name label
Turn Ava and Reed into Reed, A. for name labels and short lists.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TRIM(B8)="" | Checks whether the last name is empty. | Not empty |
| 2 | TRIM(B8) | The last name, without stray spaces. | "Reed" |
| 3 | IF(TRIM(A8)…) | Adds a comma and the first initial, if there is one. | "Reed, A." |
| 4 | IF( … ) | Shows nothing when the last name is empty. | "Reed, A." |
UPPER(LEFT(…,1)) keeps one capital letter. An empty first name shows the last name alone.
=IF(TRIM(B8)="","",TRIM(B8)&IF(TRIM(A8)="","",", "&UPPER(LEFT(TRIM(A8),1))&"."))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 first and last names into the green columns of the Template tab. Labels fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
A row with no first name shows the last name alone, with no initial. Fill those in if you can.
Route: Get names ready for the letter
Microsoft's help: LEFT function
OTHER ROUTES YOU MIGHT LIKE

Hyphenate two last-name columns
Reed + Park → Reed-Park
Get the template →
Put a preferred name in the middle
Ava + Avie + Reed → Ava (Avie) Reed
Get the template →
Make a Dear Title Last Name greeting
Dr. + Reed → Dear Dr. Reed,
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →