View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Vivek Vivek is offline
external usenet poster
 
Posts: 22
Default conversion of MS word document to MS excel Sheet

Hi frenz,
After a complete search as well as ur's help i got the solution. here it is:
copy the contents of the .rtf i.e msword file and paste it to the excel, now
goto Data-text to columns- select delimiter in 1st step- select given
options as
delimiters according to your word content in 2nd step- keep it default in
3rd step.
That's it no need to change the word content in table here.

Neways thanks to all

"Gord Dibben" wrote:

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"?