On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Monday, September 26, 2016

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. For Example:


Syntax

  =CHAR(Number)  


 The Number must be between 1 and 255.

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.