Practice free

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 é.

Practice this in the app

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.

FormulaExcel showsCase
=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 .