# How To Generate A Random Letter

## Example

=CHAR(RANDBETWEEN(B3,C3))

## 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.

### 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.

### Subscribe

Subscribe for awesome Microsoft Excel videos ðŸ˜ƒ

## Related Posts

#### 8 Ways to Apply a Formula to an Entire Column in Microsoft Excel

Are you wondering how to apply a formula to an entire column in Excel? Read...

#### 5 Ways to Lock and Unlock Formulas in Microsoft Excel

Do you want to lock the formulas in your Excel sheet to prevent other users...

#### 9 Ways to Show Formulas in Microsoft Excel

This post is going to show you all the different ways you can show the...