Random text values

An excel formula to random text values

Related Functions

Sponsored Link

 Random text values

To quickly fill a range of cells with random text values, you can use a formula based on the CHOOSE and RANDBETWEEN functions.

In the example shown, the formula in C5 is:


Which returns a random color from the values provided.

How this formula works

The CHOOSE function provides the framework for this formula. Choose takes a single numeric value as its first argument (index_number), and uses this number to select and return one of the values provides as subsequent arguments, based on their numeric index.

In this case, we are using four values: Red, Blue, Green, and Pink, so we need to give CHOOSE a number between 1 and 4.

To generate this number, we use RANDBETWEEN, a function that returns a random integer between a bottom and top value. Since we are only working with 4 values in CHOOSE, we supply 1 for the bottom number and 4 for the top number.

When this formula is copied down, it will return one of the four colors.

Note that RANDBETWEEN will calculate a new value whenever the worksheet is changed. Once you have values in the range, you may want to replace the formulas with values to prevent further changes. 

Sponsored Link

0 votes. 0 / 5