What is displayed as a character is also treated internally by the computer as a number.
The CHAR function allows you to specify a numeric value and get the corresponding character.
It works in the opposite way to the CODE function.
How it works
|number||Required argument.||Specify the numeric code to get the corresponding character.|
Here are some examples of formulas and results.
Although it is rarely used alone, it is used when you want to include special characters in a formula.
Spill if the parameters is a cell range.