How To Generate A Random Letter

Example

=CHAR(RANDBETWEEN(B3,C3))

Download Example File

Generic Formula

=CHAR(RANDBETWEEN(Lower,Upper))

Lower – This is an integer value and will depend on what type of character you want to generate.
Upper – This is an integer value and will depend on what type of character you want to generate.

What It Does

This formula will generate a random letter or symbol.

How It Works

RANDBETWEEN(Lower,Upper) will generate a random integer value between the Lower and Upper values. We then convert this randomly generated number into its ASCII character equivalent using the CHAR function.

CHAR(N) for N = 65 to 90 will result in the characters A to Z
CHAR(N) for N = 97 to 122 will result in the characters a to z
CHAR(N) for N = 33 to 47 will result in the characters ! ” # $ % & ‘ ( ) * + , – . /
CHAR(N) for N = 58 to 64 will result in the characters : ; < = > ? @
CHAR(N) for N = 91 to 96 will result in the characters [ \ ] ^ _ `

In our example RANDBETWEEN(65,90) resulted in a value of 84 and CHAR(84) returns the character T.

About the Author

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.