UNICHAR function

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.
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false