Microsoft KB Archive/65876

{| = Random Letter Generation in Excel =
 * width="100%"|

Last reviewed: November 30, 1994

Article ID: Q65876 The information in this article applies to:
 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for OS/2, versions 2.2, 2.21, 3.0
 * Microsoft Excel for the Macintosh versions 2.x, 3.0, 4.0

SUMMARY
The following formulas will generate random letters of the English alphabet when calculated:

Uppercase: =CHAR(TRUNC(RAND*26)+65) Lowercase: =CHAR(TRUNC(RAND*26)+97)

Combination of above: =CHAR(TRUNC(RAND*26)+TRUNC(RAND*2)*32+65)
 * }