Any excel nerds out there?

[ZForce915]

Usually I'm pretty handy in Excel but I'm having a bitch of a time getting this problem solved.

I want to take the rankings chart here:
http://sports.espn.go.com/fantasy/football/ffl/story?page=NFLDK2K12ranksQB

And convert it to excel. I can't seem to find a great way of doing it. I plan on doing it for each position.

Thoughts?

 

[Salamando3000]

Highlighting the entire table -> Copy -> Paste not working for you?

 

[ZForce915]

[quote name='Salamando3000']Highlighting the entire table -> Copy -> Paste not working for you?[/QUOTE]

Shows up all in cell A1.

 

[ZForce915]

Paste special -> text

That was my answer. It was copying as HTML.

I knew the answer was just eluding me.

 

[Salamando3000]

version of Excel / browser? Might also try pasting into notepad/wordpad first to remove formatting.

 

[Jodou]

[quote name='ZForce915']Paste special -> text

That was my answer. It was copying as HTML.

I knew the answer was just eluding me.[/QUOTE]
Another dirty workaround is just dump it to notepad and copy/paste. Good way to preserve any formatting you already have because sometimes stuff carries over.

And elle oh elle, it was already mentioned.

 

[nasum]

and text to columns as well so you can actually sort your sheeat