The Excel UNICHAR function returns a Unicode character based on a given number.
Syntax:= UNICHAR (number)
The UNICHAR function syntax has the following arguments:
- Number Required. Number is the Unicode number that represents the character.
Example: Let’s look at some Excel UNICHAR function examples and explore how to use the UNICHAR function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following UNICHAR examples would return:
- The Unicode character that is returned can be a string of characters, for example in UTF-8 or UTF-16 codes.
- If Unicode numbers are partial surrogates and data types that are not valid, UNICHAR returns the #N/A error value.
- If numbers are numeric values that fall outside the allowable range, UNICHAR returns the #VALUE! error value.
If number is zero (0), UNICHAR returns the #VALUE! error value.