CHAR

Converts 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 numerical Unicode map value of the first character in the string provided.

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

Examples