Next to the names, put in the formula

=rand()

then drag fill down the column. Sort all the data with this column as the
sort key.

Regards,
Tom Ogilvy


Steve wrote in message
thlink.net...
My worksheet has 1000+ names in alphabetical order. How can I put the
names in
random order?

Thanks!

Steve