We can generate **Random Text** **Values or Letters **from a list by using the **RANDBETWEEN** and **CHOOSE functions**. This step by step tutorial will assist all levels of Excel users in generating random values between two numbers.

*Figure 1: Generated Random Text Values*

**Setting up the Data**

We will input the values as shown in figure 2 into **Column A** and **Column B**

* Figure 2: Setting up the Data*

**Syntax**

**=****CHOOSE****(****RANDBETWEEN****(1,4),"Value1","Value2","Value3","Value4")**

**Explanation**

- RANDBETWEEN function

We use the RANDBETWEEN function to generate an arbitrary number from a top and bottom value. This function uses the syntax,** =RANDBETWEEN(bottom, top),** where the bottom value is the lowest value in the range and top is the highest value in the range.

RANDBETWEEN function returns only numbers and not text. This is why we need the **CHOOSE **function.

- CHOOSE function

We will use the CHOOSE function to return a value from our list of subjects in the formula. This function returns a value based on a specified index. Its syntax is,

. **=CHOOSE(index, val1, [val2], …[valn],)**

The index is the position in the list where the value will be extracted from.

Val1, [val2], …[valn] is the list that is used.

**Formula**

`=CHOOSE(RANDBETWEEN(1,4),"Chemistry","Physics","Geography","Mathematics")`

**Assigning Random Text Values**

- We will click on
**Cell****B4**and**insert the formula**

* Figure 3: Inserting the formula*

- We will press
**enter**

* Figure 4: First Random Text Value*

- We will drag the formula from
**Cell****B4 to B14**

* Figure 5: Generated Random Text Values*

**Note**

The RANDBETWEEN function will generate a new value once we change our worksheet or exit it and return. This is the reason for the change in the value of **Cell B4** in figure 4 and figure 5.* *

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment