Author: Oscar Cronquist Article last updated on December 03, 2018

Use the UNICHAR function to calculate a character based on a number.

Excel Function Syntax



number Required. The Unicode number for which you want the corresponding character.


The calculated value can be a string of characters, for example UTF-8 or UTF-16.

The UNICHAR function returns:

  • #N/A error value if data type is not valid.
  • #VALUE! error
    • if number is 0 (zero).
    • if outside the range.