Capitalize given names, keep surnames
Turn AVA and van Dijk into Ava van Dijk, with the surname left as typed.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | PROPER(A8) | Makes the given name start with a capital. | "Ava" |
| 2 | &" "& | Adds a space. | "Ava " |
| 3 | B8 | Adds the surname exactly as typed. | "Ava van Dijk" |
| 4 | TRIM( … ) | 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.
- See it work. The Example tab shows 20 made-up names with the formula already in.
- 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.
- 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
OTHER ROUTES YOU MIGHT LIKE

Use an uppercase surname
AVA + Reed → Ava REED
Get the template →
Put two household names in A to Z order
Noah Park + Ava Reed → Ava Reed & Noah Park
Get the template →
Add a former surname when supplied
Ava + Reed + Park → Ava Reed (formerly Park)
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →