![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I have a word document which contains tables of data. When I am trying to
copy the tables of data to Excel, I am right clicking the mouse and it has options to copy a picture. So while the data appears to be a MSWord table, it is actually a 'picture'. I want to just grab the raw text, paste it in excel and start some analysis. Any suggestions how I can edit the picture and get the raw text into Excel? |
| Ads | |
|
#2
|
|||
|
|||
|
Paste special html format will insert the table content as a table.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ec17 wrote: I have a word document which contains tables of data. When I am trying to copy the tables of data to Excel, I am right clicking the mouse and it has options to copy a picture. So while the data appears to be a MSWord table, it is actually a 'picture'. I want to just grab the raw text, paste it in excel and start some analysis. Any suggestions how I can edit the picture and get the raw text into Excel? |
|
#3
|
|||
|
|||
|
When I try paste special, I don't get HTML as an option to select, rather:
Picture (PNG) Picture (JPEG) Picture (GIF) Picture (Enhanced metafile) MS Office drawing object "Graham Mayor" wrote: Paste special html format will insert the table content as a table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ec17 wrote: I have a word document which contains tables of data. When I am trying to copy the tables of data to Excel, I am right clicking the mouse and it has options to copy a picture. So while the data appears to be a MSWord table, it is actually a 'picture'. I want to just grab the raw text, paste it in excel and start some analysis. Any suggestions how I can edit the picture and get the raw text into Excel? |
|
#4
|
|||
|
|||
|
Did you select the table before copying to the clipboard?
Which versions of Word/Excel are you using? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ec17 wrote: When I try paste special, I don't get HTML as an option to select, rather: Picture (PNG) Picture (JPEG) Picture (GIF) Picture (Enhanced metafile) MS Office drawing object "Graham Mayor" wrote: Paste special html format will insert the table content as a table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ec17 wrote: I have a word document which contains tables of data. When I am trying to copy the tables of data to Excel, I am right clicking the mouse and it has options to copy a picture. So while the data appears to be a MSWord table, it is actually a 'picture'. I want to just grab the raw text, paste it in excel and start some analysis. Any suggestions how I can edit the picture and get the raw text into Excel? |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Editing a Table Pasted from Excel into Word as a Picture (Enhanced Metafile) | Brooks | Microsoft Word Help | 3 | February 14th 07 03:41 PM |
| edit excel chart when it has been pasted into word | snelly | Microsoft Word Help | 1 | April 9th 06 05:06 PM |
| edit my pasted excel graph in word | ila | Microsoft Word Help | 1 | January 14th 06 05:26 PM |
| Word 2003 can't select picture editor in tools edit menu or edit p | Perplexed in Brooklyn | Microsoft Word Help | 6 | July 3rd 05 10:26 AM |
| Can I edit or remove text from a picture | Den | Microsoft Word Help | 1 | December 29th 04 10:40 PM |