View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default conversion of MS word document to MS excel Sheet

What are you expecting?

You cannot convert a word file to an Excel file.

You can copy and paste............each line of text with a linefeed will
become one cell in Excel.

You can split it out using DataText to Columns.

You could convert in Word to a Table then copy to Excel.

You could use the save as *.txt method suggested by Gordon.

Whatever method you use will require manipulation in Excel.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 04:37:00 -0700, Vivek
wrote:

Actually the file contains texts with frequent use of TAB and delimiters,it's
not a simple MSword document(.rtf).

"Gordon" wrote:

"Vivek" wrote in message
...
Hi Gordon,
Have you ever tried it?


Yes - just done it. What do you mean exactly by "it's not working"?