Converting tables from Word to Excel

  • Thread starter Thread starter Jane E. Duffany
  • Start date Start date
J

Jane E. Duffany

I am trying to convert a table from Word to Excel, version
97. The table includes dates and text. I am having no
luck. I can get it to convert but it doesn't look right.

Can someone help me?
 
Hi Jane
what exact problems did you encounter?
You may also post some example data with your wong results (plain
text - no attachments please)
 
Is your problem that the lines in a "cell" in the word table go to multiple
cells in excel?

If yes,

Inside Word, select the table and do two Edit|Replaces.
First one replaces paragraph mark (^p) with a unique string ($$$)
second one replaces manual line break (^l) (lowercase ELL) with $$$

Then copy the table and paste into Excel.

then do an Edit|Replace within excel.
Replace $$$
with hit and hold the alt-key and type 0010 from the number pad
(It may look like nothing was entered, but try it.)

alt-0010 is the same as the alt-enter to wrap to a new line in an excel cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top