Jimbo 175 Posted February 5, 2006 Share Posted February 5, 2006 I'm trying to update my works fantasy football spreadsheet, at work I use Excel, Office 97, and at home I use office 2003, at work I can copy and paste the players points table from the sun website directly and it pastes all the data nicely into rows and colums. However at home using Office 2003, when I paste the table into the spreadsheet, it pastes it all into one cell. Any ideas ??? Link to comment Share on other sites More sharing options...
Jimbo 175 Posted February 5, 2006 Author Share Posted February 5, 2006 Sussed it, "paste special" then choose paste as text instead of default html. Link to comment Share on other sites More sharing options...
Smooth Operator 10 Posted February 6, 2006 Share Posted February 6, 2006 Use paste special and use paste as text instead of default setting. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now