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.
--
Gary's Student


"Jetson2k" wrote:

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.