How To Generate Random Text From The List In Excel

How To Generate Random Text From The List In Excel

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

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

Remember that every time the formula will generate a new text. It can be used for random password generation.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References