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