copying the list sounds like a one time operation. Just select your data, do
edit=Copy, then go to excel, and paste it into the worksheet. Doing it
from you link resulted in a single column of data.

With the data in Excel (data starts in A1), put =Rand() in B1 then drag
fill down the column.

Now select both columns and do Data=Sort and use Column B as the first
column. Select the data in A1 to A10.

that gave me:

KMPH
WTTO
WWAC
WNOL
KISU
KOMU
WUFT
WHPX
KTTU
WGCU


resort if you get any state names in the top 10, or remove them before
sorting.

Each time you sort, the numbers generated by rand will be regenerated with a
new set, so you can get a new sort order.

--
Regards,
Tom Ogilvy


Patrick Fagan wrote in message
...
Hello. I have a list in MS Word format of a few hundred TV stations
categorized by state.

1) I would like to import this file, which is in three-column format in MS
Word, into Excel.

2) I would like to have Excel randomly select 10 of these TV stations.

I know #1 is relatively easy, although my importing does not look right
when
I attempt it. However, is #2 possible? Does anybody have a macro that will
do this for me?

Here is the link to the MS Word file. It is 96kb:

http://workingpapers.org/tester/TVSTATIONS.doc