Welcome to WebmasterWorld Guest from 54.197.94.141

Forum Moderators: open

Message Too Old, No Replies

convert word table to excel table

Cut and paste just doesn't work

   
11:57 pm on Oct 26, 2005 (gmt 0)

10+ Year Member



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)

10+ Year Member



Lobo

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.

HTH

Graham

8:52 am on Oct 27, 2005 (gmt 0)

WebmasterWorld Senior Member suzyuk is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Copy/Paste should work,

When pasting try right click and select Paste Special, select Text as the paste option