Capitalize given names, keep surnames

Turn AVA and van Dijk into Ava van Dijk, with the surname left as typed.

What you'll make

In Excel: AVA + van Dijk becomes Ava van Dijk.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1PROPER(A8)Makes the given name start with a capital."Ava"
2&" "&Adds a space."Ava "
3B8Adds the surname exactly as typed."Ava van Dijk"
4TRIM( … )Removes any extra spaces."Ava van Dijk"

Read it left to right. Only the given name is changed, so the surname keeps its capitals.

=TRIM(PROPER(A8)&" "&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. On the Template tab, paste each given name into column A. Put each surname, spelled the way the person writes it, into column B.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Some given names have a capital in the middle. This gives only the first letter a capital, so check those by eye.

Route: Get names ready for the letter

Microsoft's help: PROPER function