Need to generate a random number? Excel has two formula variations that can do that for you.
The first is RAND, it generates a random value between 0 and 1. But if you need larger values, try RANDBETWEEN.
RANDBETWEEN generates random numbers between a bottom and top value that you specify.
Lastly, if you need to generate a random letter value – try this formula: =CHAR(RANDBETWEEN(65,90))
In this formula the CHAR function returns the character symbol specified by a number. Letters A-Z are between 65 and 90.