A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Wrd tables to excel



 
 
Thread Tools Display Modes
  #1  
Old September 12th, 2007, 03:33 PM posted to microsoft.public.word.tables
[email protected]
external usenet poster
 
Posts: 4
Default 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  
Old September 12th, 2007, 07:40 PM posted to microsoft.public.word.tables
Tom Conrad[_2_]
external usenet poster
 
Posts: 162
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.