Excel functions / Text
UNICHAR function
The character with a Unicode number: letters of any alphabet, symbols, emoji.
Syntax
=UNICHAR(number)
Arguments
number: The Unicode number of the character.
When to use it
UNICHAR gives the character with a given Unicode number: any letter, symbol or arrow. It is how a formula puts a tick, a cross or an arrow into a cell.
Examples
A tick or a cross
A B C D 1 Name Score 2 Ana 72 ✓ 3 Ben 48 4 Chloe 90 5 Dev 65 6 Eve 81 In D2:
=IF(B2>=50, UNICHAR(10003), UNICHAR(10007))→ ✓An arrow
A B C 1 Code 2 8593 ↑ In C2:
=UNICHAR(A2)→ ↑
Common mistakes
- Symbols the font lacks. A character the cell's font does not have shows as a box. Common ticks and arrows are in every font.
UNICHAR in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: UNICHAR
- Danish: UNICHAR
- Dutch: UNITEKEN
- Finnish: UNICODEMERKKI
- French: UNICAR
- German: UNIZEICHEN
- Hungarian: UNIKARAKTER
- Italian: CARATT.UNI
- Norwegian: UNICODETEGN
- Polish: ZNAK.UNICODE
- Portuguese (Brazil): CARACTUNICODE
- Portuguese (Portugal): UNICARÁT
- Russian: ЮНИСИМВ
- Spanish: UNICAR
- Swedish: UNITECKENKOD
- Turkish: UNICODEKARAKTERİ