|
|
Correctly copy and paste tables from the web into Excel
Excel has a nice feature that can convert any data (not just web tables) in a single column to separate columns. Use: Data-->Text to columns....
Correctly copy and paste tables from the web into Excel
To make your life even easier, you can customize a toolbar to include that command as a feature.
Excel Web Query Creation instructions
took some diggin, but:
Correctly copy and paste tables from the web into Excel
I tried the suggestion using Firefox and still wound up having everything pasted into a single column. But I did find a solution.
Correctly copy and paste tables from the web into Excel
Thie method (viewing the source then copy/paste into Excel) is the method I've been using for quite a while. I'm pretty sure it's worked since Excel 2001 on OS 9. I use it all the time from any browser into Excel v.X. |
SearchFrom our Sponsor...Latest Mountain Lion HintsWhat's New:HintsNo new hintsComments last 2 daysLinks last 2 weeksNo recent new linksWhat's New in the Forums?
Hints by TopicNews from Macworld
From Our Sponsors |
|
Copyright © 2014 IDG Consumer & SMB (Privacy Policy) Contact Us All trademarks and copyrights on this page are owned by their respective owners. |
Visit other IDG sites: |
|
|
|
Created this page in 0.13 seconds |
|