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:

In the figure below the user has input the number 47 in cell A1, the mapped character is shown in cell B1:

In the figure below the user has input the number 100 in cell A1, the mapped character is show in cell B1:

This can be achieved by writing the formual below in cell B1:

=CHAR(A1)


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