Join up to three names with a final and
Turn Ava, Noah and Mia into one line for cards and invitations.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TRIM(A8) | The first name, without stray spaces. | "Ava" |
| 2 | IF(TRIM(B8)…) | Adds the second name after a comma, or after and. | "Ava, Noah" |
| 3 | IF(TRIM(C8)…) | Adds and with the third name, if there is one. | "Ava, Noah and Mia" |
Read it left to right. Part 2 uses and when there is no third name. No comma goes before and.
=TRIM(A8)&IF(TRIM(B8)="","",IF(TRIM(C8)=""," and ",", ")&TRIM(B8))&IF(TRIM(C8)="",""," and "&TRIM(C8))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 up to three names into the green columns of the Template tab. Leave the last ones empty for fewer names.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Names are joined in the order of the columns. Check the order before you send.
Route: Get names ready for the letter
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Choose a person or organization label
Person + Ava Reed + Acme → Ava Reed
Get the template →
Make an initial-and-surname username
Ava + Reed → areed
Get the template →
Make a suggested first.last name label
Ava + Reed → ava.reed
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →