| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|convert word table to excel table|
Cut and paste just doesn't work
| 11:57 pm on Oct 26, 2005 (gmt 0)|
does anyone know how I can convert a word table in to excel spreadsheet?
Would much rather not have to re-enter all those details ....
cut and paste just distorts the excel table ..
I would be grateful for some ideas or indeed a solution ...
I need to maintain the columns ...
| 8:46 am on Oct 27, 2005 (gmt 0)|
There may be different (and better ways) and depending on what version of MS Office you are using, but one way is to:
* Save the Word document, that contains the table, as a web page
* In Excel, use the Data >> Import External Data >> New Web Query option.
This would allow you to select the table, from the web page, that you would like to import.
| 8:52 am on Oct 27, 2005 (gmt 0)|
Copy/Paste should work,
When pasting try right click and select Paste Special, select Text as the paste option
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved