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.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
16212984882660852379
true
Search Help Center
true
true
true
true
true
35
false
false