Related Functions:

The UNICHAR function returns the Unicode character that is referenced by the given numeric value. 

  • This function was introduced in Excel 2013 and so is not available in earlier versions.Syntax

=UNICHAR(number)

Arguments

Argument Description
number The Unicode number that represents the character

Note: The Unicode character that is returned can be a string of characters, for example in UTF-8 or UTF-16 codes.

Examples

  A B C D
1 Number Formula Result Notes
2   =UNICHAR(66) B Returns the character represented by the unicode number 66; uppercase B
3 32  =UNICHAR(A3)   Returns the character represented by the unicode number 32; space character
4 0 =UNICHAR(A4) #VALUE! The unicode number 0 returns the error value #VALUE!

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either:

  the supplied number is zero (o) or outside the valid range
  the supplied number argument is not recognized as a numeric value
#N/A! Occurs if the supplied number argument is a partial surrogate