Turn a code like \u00e9 back into a letter
Turn Jos\u00e9 Williams from an export into José Williams.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | ISERROR(FIND("\u",A8)) | Checks if the name has no \u code. | No, it has one |
| 2 | before,TEXTBEFORE(A8,"\u"),tail,… | Splits the name around the \u. | "Jos" and "00e9 Williams" |
| 3 | cp,HEX2DEC(LEFT(tail,4)) | Reads the four characters after \u as a letter number. | 233 |
| 4 | IFERROR(before&UNICHAR(cp)&…) | Puts that letter between the two pieces. | "José Williams" |
| 5 | IF( … ) | Keeps the name as typed if part 1 says yes, else uses part 4. | "José Williams" |
Parts 2 to 4 sit inside LET, which names each piece so it can be reused. The names here are made-up.
=IF(ISERROR(FIND("\u",A8)),A8,LET(before,TEXTBEFORE(A8,"\u"),tail,TEXTAFTER(A8,"\u"),cp,HEX2DEC(LEFT(tail,4)),IFERROR(before&UNICHAR(cp)&MID(tail,5,LEN(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 names. Paste exported names into the green column of the Template tab. The decoded names fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This fixes one \u code per name. If a name has two or more, decode it in the program that exported it.
Microsoft's help: HEX2DEC function
OTHER ROUTES YOU MIGHT LIKE

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 →
Remove a CDATA wrapper, keep &
<![CDATA[Ava & Noah Reed]]> → Ava & Noah Reed
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →