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.
 
You must log in or register to reply here.

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

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
How to Convert MBOX to PST Online? 3
Converting word document to excel 1
excel to Word 1
How can we convert OST to PDF file format? 1
How can I migrate MBOX to PST? 2
Converting Word documents into Excel document 1
Table in Word to Excel 2

Back
Top