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