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:

Where,

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

 

Example of UNICHAR Function in Excel:

Formula

RESULT

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