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:
Syntax: =UNICHAR(A2)
Result:
Based on the Excel spreadsheet above, the following UNICHAR examples would return:
Syntax: =UNICHAR(A3)
Result: h
Syntax: =UNICHAR(A4)
Result: ^
Syntax: =UNICHAR(A5)
Result: $
Syntax: =UNICHAR(A6)
Result: ◐
Syntax: =UNICHAR(A7)
Result: 🙂
Syntax: =UNICHAR(A8)
Result: ★
Syntax: =UNICHAR(A9)
Result: ©
Syntax: =UNICHAR(A10)
Result: ¥
Syntax: =UNICHAR(A11)
Result: €
Syntax: =UNICHAR(A12)
Result: µ
Syntax: =UNICHAR(A13)
Result: ®
Syntax: =UNICHAR(A14)
Result: Space character
Note:
- 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.
