Here's one way to do that....

Assuming your list of words is in A1:A10 this formula gives you one of
those at random

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

note that every time worksheet is re-calulated, the result is generated
again, you can trigger that by hitting F9


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537623