Get first name from Last, First Middle
Pull Ava out of Reed, Ava Marie, for greetings like Dear Ava.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TRIM(TEXTAFTER(A8,",")) | Takes what comes after the comma, minus stray spaces. | "Ava Marie" |
| 2 | &" " | Adds a space, so one-word names work too. | "Ava Marie " |
| 3 | " " | Where to cut: the first space. | " " |
| 4 | TEXTBEFORE( … ) | Keeps everything before that space. | "Ava" |
| 5 | IFERROR( … ) | Shows nothing if there is no comma. | "Ava" |
Read it left to right. A name with no comma stays blank.
=IFERROR(TEXTBEFORE(TRIM(TEXTAFTER(A8,","))&" "," "),"")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 Last, First Middle names into the green column of the Template tab. First names fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Only the first word is kept, so Mary Ann becomes Mary. Check two-word first names before you send.
Route: Get names ready for the letter
Microsoft's help: TEXTBEFORE function
OTHER ROUTES YOU MIGHT LIKE

Get middle names from Last, First
Reed, Ava Marie Anne → Marie Anne
Get the template →
Get first part of hyphenated last name
Reed-Park → Reed
Get the template →
Get the rest of a hyphenated last name
Reed-Park → Park
Get the template →
Fix "Dear ," when a first name is blank
(blank) → Dear colleague,
Take this route →