In this Excel tutorial, you will learn how to generate random text from a list.

## Random text generator formula

Suppose that your list is in the A1: A10 cell range. You have some text there from which you want to generate one in some other cell. Here is an Excel formula that solves your problem:

**=INDEX(A1:A10,RAND()*ROWS(A1:A10)+1) **

Drag it down to the number of cells you need it in.

Remember that every time the formula generates a new text, Each time you run the formula, it will generate a random item from a given list.

It can be used for random password generation.