How to Use CHAR in Google Sheets in 2020?

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

Sample Usage






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.


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.