Returns the Unicode character for a number. This method supports returning characters in both the UTF-8 and UTF-16 character set.
Parts of a UNICHAR function
UNICHAR(number)
Part | Description |
number |
Required. The number to convert into a Unicode character. The number should be greater than 0. |
Sample formulas
Example 1: UNICHAR(68) returns D
Example 2: UNICHAR(307) returns \u0133, which may appear as ij
Notes
- If number is 0, the method returns a #VALUE error.
- If the number does not have a Unicode character, the method returns a #VALUE error.
- It is possible that the method’s output changes overtime as the Unicode character set is refined.
Examples
Result for =UNICHAR(68)
A | B | |
1 | D | |
2 |
Result for =UNICHAR(307)
A | B | |
1 | ij | |
2 |
Related functions
- UNICODE: The
UNICODE
function returns the decimal Unicode value of the first character of the text.