conversion of MS word document to MS excel Sheet

  • Thread starter Thread starter Vivek
  • Start date Start date
V

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 )
 
Vivek said:
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 )
Click to expand...


In Word Save-As text file, in Excel open Txt file.
 
Hi Gordon,
Have you ever tried it? coz it's not working in my case. still
clueless!!!!!!!!
 
Actually the file contains texts with frequent use of TAB and delimiters,it's
not a simple MSword document(.rtf).
 
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
 
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
 
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
 
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
 
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
Click to expand...
 
Back
Top