Thursday, 7 May 2015

Excel CHAR Function with Example

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.

Note-
Number 32 does not show as it is the SPACEBAR character.

Previous Page Next Page Home

Popular Posts