Keep a surname particle lowercase

Turn DE LA and CRUZ into de la Cruz, with the small words kept small.

What you'll make

In Excel: DE LA + CRUZ becomes de la Cruz.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1LOWER(A8)Makes the particle all small letters."de la"
2&" "&Adds a space."de la "
3PROPER(B8)Adds the rest with a capital first letter."de la Cruz"
4TRIM( … )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.

  1. See it work. The Example tab shows 20 made-up names with the formula already in.
  2. 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.
  3. 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