UNICHAR Function in excel – Return character based on UNICODE in Excel

The UNICHAR Function in Excel takes up the number as an input and returns the corresponding Unicode character.

NOTE: UNICHAR Function is available from Excel 2013 onwards.

Syntax of UNICHAR Function in Excel:

UNICHAR( number )

Where,

number – number argument for which you want to find the Unicode character.

Example of UNICHAR Function in Excel:

Formula

unichar-function-in-excel-1

RESULT

unichar-function-in-excel-2

Note: #VALUE! Error occurs

if the supplied argument cannot be interpreted as a numeric value in excel
The supplied number argument is not in the range between 1 and 255