Edit text in a picture in Word (to be pasted into Excel)

E

ec17

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?
 
G

Graham Mayor

Paste special > html format will insert the table content as a table.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
E

ec17

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
 
G

Graham Mayor

Did you select the table before copying to the clipboard?
Which versions of Word/Excel are you using?
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top