CHAR Function - Excel


Overview


The CHAR function in Excel is a useful tool for returning a special character based on the ASCII code provided in the function. Its primary objective is to convert a numeric ASCII code into its corresponding character.

An example of the CHAR function in Excel

Example:

=CHAR(65)

Syntax:

=CHAR(number)

number: This is a required argument that represents the ASCII code of the character you want to retrieve.


Example


In this example, the CHAR function gives us a result of "?” because the ASCII code for the ? symbol is 63.

Another example of the CHAR function in Excel

Interactive GSheet