Excel Functions and Formulas, CHAR()
Each character is mapped to a numeric value. For example the character “A” is mapped to the number 65. The character “B” is mapped to the number 66 and so on. The CHAR() function receives an number as input and returns the character associated with that number.
Returns the character mapped to the input number.
In this example the user inputs a number in cell A1. Cell B1 returns the character mapped to that number. In the figure below the user has input the number 78 in cell A1. The mapped character is shown in cell B1: