Welcome to WebmasterWorld Guest from 23.22.220.37

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)

Preferred Member

10+ Year Member

joined:May 24, 2005
posts:554
votes: 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)

Junior Member

10+ Year Member

joined:June 4, 2003
posts:112
votes: 0


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)

Senior Member

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

joined:Oct 1, 2002
posts:5199
votes: 0


Copy/Paste should work,

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

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members