CHAR Function in Excel

 

What Does It Do?

This function converts a normal number to the character it represent in the ANSI character set used by Windows.

Syntax

=CHAR(Number)

The Number must be between 1 and 255.

Formatting

The result will be a character with no special formatting.

Example

The following is a list of all 255 numbers and the characters they represent.

Note that most Windows based program may not display some of the special characters, these will be displayed as a small box.