This post demonstrates how to generate random letter in excel for some random assigning purpose.
Let’s understand how to generate random letter in excel.
We will see how to generate random letters in excel with the help of RANDBETWEEN and CHAR function in excel.
CHAR function returns the character equivalent of a number in excel.
RANDBETWEEN function returns a random number between the limit specified in the formula.
In excel the character code of letter A is 65 and character code of Z is 90 that’s why we have used 65 and 90 so that the letter generated is between A and Z
Step 1
Select the range which you want to fill with random letter.
Step 2
Press F2 to enter the formula =CHAR(RANDBETWEEN(65,90))
Step 3
Press Ctrl+Enter to populate the formula in the selected range.
Step 4
Now copy the range and paste special as values as shown below.
Hope this helped.
