Forum Discussion
Where do you use Char Function
Hi,
Please read this https://support.office.com/en-us/article/CHAR-function-BBD249C8-B36E-4A91-8017-1C133F9B837A and https://exceljet.net/excel-functions/excel-char-function to learn more about this function.
This function opens doors to solve many problems and create many solutions.
Here is an example:
What if you want to create a formula to generate a random letter?
If so, you can depend on CHAR function to do that for you as below:
=CHAR(RANDBETWEEN(65,90))
RANDBETWEEN function returns a random number between two numbers you specify, and we know that the code numbers of the alphabetic characters A-Z are from 65 to 90.
So RANDBETWEEN will return that random number for us, and then CHAR function will take this number and convert it to its associated letter.
Hope that helps