CHAR

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

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:

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

Keep Reading Similar Functions:

corresponding code of a character in Excel

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

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

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

Read More »