pick from letters A-Z?

[hulton]

I would like to randomly pick letters from A to Z each time I ask the sheet
to get a new letter

 

[Sheeloo]

Try

=CHAR(ROUND(RAND()*25+1,0)+64)

 

[David Biddulph]

Doesn't that give half the probability for A or Z compared with the other
letters?

=CHAR(RANDBETWEEN(65,90)) if you've got ATP installed, or
=CHAR(INT(RAND()*26)+65) or possibly just
=CHAR(RAND()*26+65)