How to Use CHAR Function

The CHAR function is to return an integer number from 0 to 255 to the specified character.


= CHAR(number)


– The number is required; the number you need to translate into character.


– Only numbers from 0 to 255 will be translated into characters.

– Some translated characters may not show up based on your computer.

– Numbers over 255 will return to #VALUE!.

Example: What is the character represented by 65 and 66?

= CHAR(65), which returns to the letter A;
= CHAR(66), which returns to the letter B.

Download: CHAR Function

Leave a Reply