Return the corresponding ANSI character of a number.
The Excel CHAR function display characters based on the underlying numeric codes. The set of such characters is called the ANSI character set, and numbers assigned to each character are called the ANSI codes. For example in Window, = CHAR(33) in Excel returns “!” (exclamation mark).
number – An integer between 1 and 255 (ANSI code).
A character represented by an ANSI code.
The CHAR function result is the opposite of the CODE function.
The Microsoft Excel CHAR function returns the character based on the ASCII value.
Return of a character set is based on the operating environment of a computer: