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
|
|||
|
|||
Copying a table from Word 2000 to Excel 2000
I am having a problem with formating when I copy a table
from a word document into excel. Someone in my company decided to use Word to make a very large table. As this is fairly useless to us in Word format, I am trying to port it over to Excel. The problem is in how Excel formats the table. In Word, some of the cells of the table have multiple groups of text seperated by a blank line within the same cell. (Basically paragraphs). When it is copied into excel each of these paragraphs becomes its own cell instead of the paragraphs being in one cell as they are in the Word table. So, my question is, is there anyway to copy it over without it making all these extra cells in the excel format. As it is, I have been copying and pasting from the seperate paragraph cells into one cell. This is obviously very tedious. Any help is appreciated. |
#2
|
|||
|
|||
Copying a table from Word 2000 to Excel 2000
Dear Mike
Select the entire Word table, and copy it. Move to the relevant insertion point in Excel and then Edit/Paste Special/Unicode Text. That should do the trick. Hope this helps Paul Falla -----Original Message----- I am having a problem with formating when I copy a table from a word document into excel. Someone in my company decided to use Word to make a very large table. As this is fairly useless to us in Word format, I am trying to port it over to Excel. The problem is in how Excel formats the table. In Word, some of the cells of the table have multiple groups of text seperated by a blank line within the same cell. (Basically paragraphs). When it is copied into excel each of these paragraphs becomes its own cell instead of the paragraphs being in one cell as they are in the Word table. So, my question is, is there anyway to copy it over without it making all these extra cells in the excel format. As it is, I have been copying and pasting from the seperate paragraph cells into one cell. This is obviously very tedious. Any help is appreciated. . |
Thread Tools | |
Display Modes | |
|
|