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:
Where the number argument is an integer that you want to return the Unicode character of.
The following spreadsheet shows the Excel Unichar function, used to return the unicode character associated with four different supplied numbers.
Formulas:
|
Results:
|
See the Microsoft Office website for further information and examples of the Excel Unichar Function.
If you get an error from the Excel Unichar function, this is likely to be one of the following:
#NUM! | - | Occurs if the supplied number argument is a partial surrogate. |
#VALUE! | - |
Occurs if either:
|