Excel UNICHAR Function

Basic Description

The Excel Unichar function returns the Unicode character relating to a supplied number.

Note: The Unichar function is new in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

UNICHAR( number )

Where the number argument is an integer that you want to return the Unicode character of.


Unichar Function Examples

The following spreadsheet shows the Excel Unichar function, used to return the unicode character associated with four different supplied numbers.

 Formulas:
 A
1=UNICHAR( 65 )
2=UNICHAR( 97 )
3=UNICHAR( 63 )
4=UNICHAR( 51 )
 Results:
 A
1A
2a
3?
43

See the Microsoft Office website for further information and examples of the Excel Unichar Function.


Unichar Function Errors

If you get an error from the Excel Unichar function, this is likely to be one of the following:

Common Errors
#NUM!-Occurs if the supplied number argument is a partial surrogate.
#VALUE!-

Occurs if either:

  • The supplied number is outside the valid range;
  • The supplied number argument is not recognised as a numeric value.