CHAR function

Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.

Syntax

CHAR(number)

Number is a number between 1 and 255 specifying which character you want. The character is from the character set used by your computer.

Examples

Formula	Description (Result)
=CHAR(65)	Displays the 65 character in the set (A)
=CHAR(33)	Displays the 33 character in the set (!)