UNICHAR function
UNICHAR returns the Unicode character for a given code point, including symbols and accented letters. It is a wider version of CHAR, and how the result looks depends on the font.
Example
Read it as a sentence: find the character for code 233, which gives é.
A
B
C
D
1
é
2
3
Syntax
UNICHAR(number)
-
number(required) - A Unicode code point.
Returns: The character for that code point.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=UNICHAR(65) | A | A |
=UNICHAR(8364) | € | Euro |
=UNICHAR(128512) | 😀 | Emoji |
=UNICHAR(65.9) | A | Fractional |
=UNICHAR("66") | B | Text number |
=UNICHAR(0) | #VALUE! | Zero |
=UNICHAR(1114112) | #VALUE! | Past last code point |
=UNICHAR(55296) | #N/A | Surrogate code point |
Watch out for
- Invalid code points give #VALUE!.
- Display depends on the font.
Where it works
- Excel
- UNICHAR arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .