Copy Word table into excel

C

Chris

I have a few documents that are over 50 pages long that have requirements in
a word table. The requirements have formatting such as Carriage returns,
bullets, and indents. What I would like to do is for each cell in word to
copy over to a single cell in excel. the problem is that every one cell in
word converts to many in excel ... which I'm thinking is mostly due to
formatting.

Is there an easy way to do this that I'm just missing?
Any ideas I should try.... thanks

Chris
 
S

Stefan Blom

For each paragraph mark (¶ with nonprinting marks displayed) within a Word
cell you will get an additional row. Try deleting the paragraph marks before
copying; to accomplish that, you can use Find and Replace.
 

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