Thread: pick from letters A-Z?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
  
Posts: 1,805
Default pick from letters A-Z?
Try

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

"hulton" wrote:

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