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.


Syntax:

=CHAR(number)

Returns the character mapped to the input number.


Example:

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:

Excel, Formulas and Functions, CHAR, Example 78
In the figure below the user has input the number 47 in cell A1, the mapped character is shown in cell B1:

Excel, Formulas and Functions, CHAR, Example
In the figure below the user has input the number 100 in cell A1, the mapped character is show in cell B1:

Excel, Formulas and Functions, CHAR, Example 100
This can be achieved by writing the formual below in cell B1:

=CHAR(A1)

Excel, Formulas and Functions, CHAR, Formula Cell B1

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com

Leave a Reply

Your email address will not be published. Required fields are marked *