Turn codes like é into characters
Turn José Muñoz into José Muñoz. Works for one code per cell.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | ISERROR(FIND("&#",A8)),A8 | Keeps the cell as it is if it has no &# code. | Not used for row 8 |
| 2 | before,…,tail,…,n,TEXTBEFORE(tail,";") | Splits the text around the code, called before, tail and n. | "Ava Reed " and "38" |
| 3 | cp,IF(LEFT(n,1)="x",HEX2DEC(…),VALUE(n)) | Reads the code number. A code with x counts in 16s. | 38 |
| 4 | IFERROR(before&UNICHAR(cp)&…,"Review character code") | Puts the real character back between the two sides. | "Ava Reed & Noah Park" |
| 5 | IF( … ) | Uses part 1 when there is no code, otherwise parts 2 to 4. | "Ava Reed & Noah Park" |
Read it left to right. & and & are the same code.
=IF(ISERROR(FIND("&#",A8)),A8,LET(before,TEXTBEFORE(A8,"&#"),tail,TEXTAFTER(A8,"&#"),n,TEXTBEFORE(tail,";"),cp,IF(LEFT(n,1)="x",HEX2DEC(MID(n,2,6)),VALUE(n)),IFERROR(before&UNICHAR(cp)&TEXTAFTER(tail,";"),"Review character code")))How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own list. Paste text with codes like é into the green column of the Template tab. The plain text fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Each cell can hold one code. A second code in the same cell stays as it is.
Microsoft's help: UNICHAR function
OTHER ROUTES YOU MIGHT LIKE

Turn a code like \u00e9 back into a letter
Jos\u00e9 Williams → José Williams
Get the template →
Decode plus-sign spaces in form text
Ava+Reed+%2B+Noah+Park → Ava Reed + Noah Park
Get the template →
Unwrap a CSV field with doubled quotes
"Ava ""Avie"" Reed" → Ava "Avie" Reed
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →