Keep a surname particle lowercase
Turn DE LA and CRUZ into de la Cruz, with the small words kept small.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | LOWER(A8) | Makes the particle all small letters. | "de la" |
| 2 | &" "& | Adds a space. | "de la " |
| 3 | PROPER(B8) | Adds the rest with a capital first letter. | "de la Cruz" |
| 4 | TRIM( … ) | Removes the extra space when there's no particle. | "de la Cruz" |
Read it left to right. TRIM wraps everything, so a blank particle leaves no gap.
=TRIM(LOWER(A8)&" "&PROPER(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 particles such as de la or van into the green columns of the Template tab. Add the rest of each surname beside them. Surnames fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Some families write their particle with a capital, like Van Dijk. Use this only when you know the small letters are right.
Route: Get names ready for the letter
Microsoft's help: LOWER function
OTHER ROUTES YOU MIGHT LIKE

Combine a middle initial and a suffix
Ava + Marie + Reed + Jr. → Ava M. Reed Jr.
Get the template →
Make a surname-first entry with a suffix
Ava + Marie + Reed + Jr. → Reed Jr., Ava Marie
Get the template →
Share a surname when surnames match
Ava Reed + Noah Reed → Ava & Noah Reed
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →