Skip to main content

CHAR

Definition

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: Converts a signed hexadecimal number to decimal format.

In order to use the CHAR formula, start with your edited Excellentable:

Then type in the CHAR formula in the area you would like to display the outcome:

By adding the values you would like to calculate the CHAR formula for, Excellentable will generate the outcome:

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.