Table in Word to Excel

[ES Nycole]

I have over 200 documents in word tables. I need to convert them all to
Excel. I have tried the copy and paste thing, but it looses it's formating.
The data is originally copied from governments standard docs, so there are
paragraph marks in unusual places. When I paste into excel it converts each
paragraph mark to a separate cell, sometimes in the middle of a sentance. Is
there an easy way to do this without spending days reformatting, resizing,
ect.???
Also... In Word there is an option to Auto-fit contents, is that possible in
Excel??

 

[MS-Exl-Learner]

Use FIND expressions in MSWORD to remove unnecessary paragraph marks.

Generallly ^p is used to find the paragraph marks in word. But I don’t know
how your table is and where the unnecessary paragraph marks are lying? So
depends upon your word document we need to use some FIND expressions OR
wildcards to format it.

So, it is difficult to say which FIND expression OR wildcard u can use. Do a
web search about MS-Word Find Expressions and WILDCARD and try it in your
duplicate copy…

All the Best!

 

[David Biddulph]

Paste into the formula bar, rather than into the cell.