Convert Word Tables (Excel 97)

[dffej]

At work I have inherited some large Word 97 tables which I need to convert to Excel 97. Not usually a problem even for a novice like me, but it is not working. In Word, some cells have multiple lines of data within the cell, with a return (Enter) at the end of each line (within the cell). On conversion in Excel this seems to have the effect of starting a new row each time a return is encountered ( just like the end of row marker from the Word table). Is there a way to convert so that these multiple lines of data in a single cell from Word with a return at the end of each line become multiple lines within a single cell in Excel? Or close to it ? Any help much appreciated.

[Andrew Cronnolly]

Try using Paste Special, and select Text. This will however result in the loss of the hard CR, which can be replaced manually unless there is too large a number of them. Excel 97 does not handle text pasting as well as Excel 2000.

Andrew C

[fburg]

Jeff,

There was another thread on this subject about a month after your posting. It's . I felt a solution was needed since I have this problem also. So I just posted a proposal for a solution on that thread in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=103898&page=0 &view=&sb=&o=&fpart=&vc=> this reply .

{edited to fix 2nd link}

Let us know on that thread if this helps.

Fred