Use an uppercase surname
Turn AVA and Reed into Ava REED, so the surname stands out on forms and badges.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | PROPER(A8) | Gives the given name one capital, then small letters. | "Ava" |
| 2 | &" "& | Adds a space. | "Ava " |
| 3 | UPPER(B8) | Adds the surname in all capitals. | "Ava REED" |
| 4 | TRIM( … ) | Removes any extra spaces. | "Ava REED" |
Read it left to right. TRIM wraps everything, so stray spaces don't show.
=TRIM(PROPER(A8)&" "&UPPER(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 given names and surnames into the green columns of the Template tab. Full names fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
A given name with a second capital inside comes out with only the first one. Fix those few by hand.
Route: Get names ready for the letter
Microsoft's help: UPPER function
OTHER ROUTES YOU MIGHT LIKE

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 →
Label DBA names only for type 3
Acme Co. + Acme + 3 → Legal: Acme Co. ¶ DBA: Acme
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →