After you put it in the first cell, r-click and "Copy" the cell. Now
select the cells in ALL the rows below it and then "Paste" in to all
the cells in the column at once. 10- 1000- 10000 whatever.

Leland5491 wrote:

I see how that works.

Now is there a way that I can copy that to 1K or 50K names all at the same
time??

Bob I wrote:

helper column is the empty column adjacent to your data.

put =RAND() in the first row and then copy it down to the rest of them

then highlight all the data (names and helper column) and pick Data,
Sort and then sort on the helper column.


Bob I am very new at this. What is a helper column?


[quoted text clipped - 12 lines]

Thank You
Leland