homepage Welcome to WebmasterWorld Guest from 174.129.103.100
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
convert word table to excel table
Cut and paste just doesn't work
Lobo




msg:1578844
 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 ...

 

Graham




msg:1578845
 8:46 am on Oct 27, 2005 (gmt 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

SuzyUK




msg:1578846
 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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved