I would like to scramble a list of words so that they are not in an
particular order. Can I do this somehow?

The simplest way is to insert =rand() in the cells next to the word column
select both columns and sort by the rand column. If you dont like the order
just sort again.
"Cate" wrote:

I would like to scramble a list of words so that they are not in an
particular order. Can I do this somehow?

Just run this formula in the cells next to the words then sort both columns:
=RAND()

Regards,
Ron

Assuming the words are in individual cells, use a help column
and in the first adjacent cell type

=RAND()


copy down

select both column and sort by the formula column,
then delete the formula column

Regards,

Peo Sjoblom

"Cate" wrote:

I would like to scramble a list of words so that they are not in an
particular order. Can I do this somehow?

what is a help column?

"Peo Sjoblom" wrote:

Assuming the words are in individual cells, use a help column
and in the first adjacent cell type

=RAND()


copy down

select both column and sort by the formula column,
then delete the formula column

Regards,

Peo Sjoblom

"Cate" wrote:

I would like to scramble a list of words so that they are not in an
particular order. Can I do this somehow?

It's an unused column that you can use to sort on. So if your words are
in A1:A20, and column B is unused, enter

B1: =RAND()

and copy down to B20. Select A1, then choose Data/Sort... and sort on
column B.



In article ,
"Cate" wrote:

what is a help column?