Put two household names in A to Z order
Turn Noah Park and Ava Reed into Ava Reed & Noah Park for one envelope.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TRIM(A8)<=TRIM(B8) | Checks whether name 1 comes before name 2, A to Z. | Yes |
| 2 | TRIM(A8)&" & "… | If so, keeps this order and joins them with &. | "Ava Reed & Noah Park" |
| 3 | TRIM(B8)&" & "… | If not, puts name 2 first. | Not used for row 8 |
| 4 | IF( … ) | Picks the right order for the row. | "Ava Reed & Noah Park" |
Sorting ignores capitals and extra spaces. Two identical names keep their order.
=IF(TRIM(A8)<=TRIM(B8),TRIM(A8)&" & "&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 each person's full name into the two green columns of the Template tab.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
The order goes by first name, not last name. Check each pair lives together.
Route: Get names ready for the letter
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Add a former surname when supplied
Ava + Reed + Park → Ava Reed (formerly Park)
Get the template →
Label DBA names only for type 3
Acme Co. + Acme + 3 → Legal: Acme Co. ¶ DBA: Acme
Get the template →
Combine first and last names
Ava + Reed → Ava Reed
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →