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
|
|||
|
|||
Copy Word table into excel
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 |
#2
|
|||
|
|||
Copy Word table into excel
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. -- Stefan Blom Microsoft Word MVP "Chris" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|