Any excel experts out there?

Steel_2

My boss has handed me a Word report to edit and proof, and a few pages in I've realised he's copied and pasted about 30 rows of information straight from an excel sheet.

He has then simply carried on typing the report, adding in excel charts (some 100 in total) into these cells....FOR 94 PAGES!!!!
So there's blue dashed grid-lines all the way through the report, and sometimes he has copied and pasted more excel information cells within cells so they've become nested. It's an absolute mess and its due with a client soon.

I don't want to (and don't have the time to) manually highlight and lift every bit of information out of every cell into a blank part of the doument.

Is there anyway to quickly strip out this Excel formating from this word document while keeping the charts and text intact?

Sooler

If it's just text in the Word doc, or parts of the Word doc ... copy the whole lot from the Word doc and paste it into Notepad, that will get you the text only. Then copy it all from Notepad into a new Word doc.

Ctrl+A in Word
Ctrl+V in Notepad
Ctrl+A in Notepad
Ctrl+V in Word

Anna_Glypta

You can also select the table, as that is what the excel section of the document actually is, and choose the table convert table to text option. Should work fine but earlier suggestion to make a copy first is very sensible.

Good luck.