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:

 

A
B
1
Data
2
65
3
35
4
5
Displays the character represented by 65 in the computer's character set:
A
6

Displays the character represented by 35 in the computer's character set:
#

JavaScript errors detected

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

If this problem persists, please contact our support.