Is there a way to copy web site data to excel to make it sortable

J

Jetson2k

I am trying to copy data from a web site and paste it into excel. this I can
do however, excel does not recognize the data. Is there a way to make excel
recognize the data so that is can be sorted. totalled etc.
 
G

Gary's Student

What you want is not difficult, just laborous. Lots of junk gets pasted when
the web content is pasted. Usually I have to erase the pictures & hyperlinks
with:

Selection.Hyperlinks.Delete
ActiveSheet.Pictures.Delete

in a macro and then unmerge cells and move things around.
 
Top