CHAR

Convert a number into a character according to the current Unicode table.

Sample Usage

CHAR(97)

CHAR(HEX2DEC("A3"))

CHAR(A1)

Syntax

CHAR(table_number)

  • table_number - The number of the character to look up from the current Unicode table in decimal format.

    • table_number must be a number in decimal format (base 10). Many tables provide Unicode values in hexadecimal format (base 16). In this case, use the HEX2DEC function to convert.

Notes

  • The current Unicode table can be found online at the unicode website or on Wikipedia.
  • Not all Unicode characters will display properly on all computers and devices. Special fonts or languages may have to be installed or enabled on your computer.

See Also

CODE: Returns the numeric Unicode map value of the first character in the string provided.

HEX2DEC: The HEX2DEC function converts a signed hexadecimal number to decimal format.

Examples

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
Main menu
13831635705609181585
true
Search Help Center
true
true
true
true
true
35
false
false