EXCEL and ESPN - Any way this works

[The Wrong Marine]

Hello Dobber community

I am guessing the answer is no but is there a way to export the data from an ESPN league roster page automatically? I can use the WebQuery but there is a lot of manual intervention to "text to columns" for each team due to the layout on ESPN. ie in the player name, they include their First Name Last Name, POS, TEAM and Injury status. I was hoping there was an easier way but not sure.



Any help would be appreciated

Cheers

[Feadur]

make a column beside it. if the name/pos/team/etc column is column B, then cell A1 should be =LEFT(B1,FIND(",",B1)-1)
that will return just the player name. flash fill the rest and you're done!

[The Wrong Marine]

Thanks works great