Return the corresponding ANSI character of a number in Excel
Returns the character specified by the code number


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).


= CHAR(number)


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:

For example in Window, = CHAR(62) in Excel returns “<” (greater than Sign).

Keep Reading Similar Functions:

corresponding code of a character in Excel


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).

Read More »
Convert a text string without number format in Excel


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”.

Read More »