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 )


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


Example of UNICHAR Function in Excel:





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

previous-small UNICHAR Function in excel                                                                                                           next_small UNICHAR Function in excel

DataScience Made Simple