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

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