UNICHAR functionReturns 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.