Site icon ExcelNotes

How to Use CHAR Function

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

Formula:

= CHAR(number)

Explanations:

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

Cautions:

– 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

Exit mobile version