Rational
Return the corresponding ANSI character of a number.
Description
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).
Syntax
= CHAR(number)
Parameters
number – An integer between 1 and 255 (ANSI code).
Return Value
A character represented by an ANSI code.
Key Notes
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:
Keep Reading Similar Functions:
CODE
The CODE function displays a unique number of each valid character based on the underlying set standard of ANSI. I.e, =CODE(B8) returns ! (exclamation mark).
VALUE
The VALUE function converts valid numbers with various number formatting (number, date, $ etc.) into a code number. E.g. “=VALUE(“31-12-2017”)” returns “43100”.