Forum Discussion
Where do you use Char Function
Hi all,
I am studying about the Excel built-in function and trying to understand the application of those.
When I see Char function it returns some type of unique characters and also the Letters and Numbers. I am ok with some unique characters. But, if we can easily enter letter and numbers, without using this type of fancy formula, Why excel is providing this type of function.
If this is helpful for you in your worksheet, I like to know where is it going to be helpful.
Your Corporation on this highly appreciated.
Thank You.
1 Reply
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
