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
|
|||
|
|||
Wrd tables to excel
I have a word table that I would like to export to excel. I am using
Word/Excel 2003. The problem I am having is that Excel breaks up the Word table cell into several cells. Is there a way around this? |
#2
|
|||
|
|||
Wrd tables to excel
Word tables that do not have merged columns or merged rows are the easiest to
import into excel. Excel will usually break apart the contents of a word table cell when the table cell contains a hard or soft paragraph character enter or shift+enter. When Excel finds these characters it creates a new row. A soft paragraph word wrapping doesn't bother excel, provided the contents of the word table cell do not exceed the maximum allowable limit for text characters in an Excel cell. Similar problems can occur when a word table columns are merged. Excel will sometimes create an extra column. Excel can also reformat number data from the word table as dates. If your word tables have merged columns or rows, then the only way that I know of to ease the import into excel problems is to select and paste individual columns or rows into excel. If a single word table cell contains multiple paragraphs then excel will past each paragraph as a seperate cell. There are other methods that are more involved, convert the word table to delimited text, etc. -- Tom Conrad " wrote: I have a word table that I would like to export to excel. I am using Word/Excel 2003. The problem I am having is that Excel breaks up the Word table cell into several cells. Is there a way around this? |
Thread Tools | |
Display Modes | |
|
|