DATA VALIDATION IN REVERSE #2 (FOR JULIE D.)

[Wayne]

I was not able to do what I wanted to do. If this is a
valid email, or perhaps with one that is, could I send you
the one and one only page (in html) that I am trying to
extract the data from a cell, and paste on seperate lines
on my Excel spreadsheets. I do statistics for sports, so
you'll understand when I send it.

If not, I'll ask thru the Forum. but I'd luvvv to get this
right.

Thank you for your input and your time in posting a reply
to my query, anyway.

Wayne
-----------
Hi Wayne

depends how you created the drop down list -
as you mentioned data / validation i'll assume that your
list is a data /
validation list that you typed into the source field - if so,
click in a cell with the drop down list and choose data /
validation
click in the source box and use CONTROL & C to copy the
information
go to a blank cell somewhere or your word document and paste
in excel the data will appear as a comma separated list, to
split it up into
different cells, click on the list, choose data / text to
columns, choose
delimited, next, untick tab, tick comma - finish
in word, select your comma separated list, choose table,
convert, text to
table, choose comma click OK

Cheers
JulieD

If I have a drop-down menu in my Excel spreadsheet, how can
I copy all of the data in this drop-down menu, and paste it
into/onto either a normal Excel spreadsheet cells, or even
on to a word file?

..