conversion of MS word document to MS excel Sheet

[Vivek]

Hi ALL,
This is Vivek here.Can anybody help me in explaining; How to convert a MS
word document to MS excel Sheet, manually ? ( it's not a word table i am
talking about )

 

[Gordon]

Hi ALL,
This is Vivek here.Can anybody help me in explaining; How to convert a MS
word document to MS excel Sheet, manually ? ( it's not a word table i am
talking about )

In Word Save-As text file, in Excel open Txt file.

 

[Vivek]

Hi Gordon,
Have you ever tried it? coz it's not working in my case. still
clueless!!!!!!!!

 

[Gordon]

Hi Gordon,
Have you ever tried it?

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

 

[Vivek]

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

 

[Gord Dibben]

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 Data>Text 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

 

[JP]

Agreed with Gord here, sounds like a "square peg, round hole" problem.

Are you sure you are using the right tool for the job?

--JP

 

[Vivek]

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

 

[Vivek]

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]

Good to hear. Thanks for the feedback.


Gord

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