Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conversion of MS word document to MS excel Sheet
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 ) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conversion of MS word document to MS excel Sheet
"Vivek" wrote in message
... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conversion of MS word document to MS excel Sheet
Hi Gordon,
Have you ever tried it? coz it's not working in my case. still clueless!!!!!!!! "Gordon" wrote: "Vivek" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conversion of MS word document to MS excel Sheet
"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"? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conversion of MS word document to MS excel Sheet
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"? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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"? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conversion of MS word document to MS excel Sheet
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 On Aug 26, 7:37*am, Vivek wrote: Actually the file contains texts with frequent use of TAB and delimiters,it's not a simple MSword document(.rtf). |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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"? |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 "JP" wrote: 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 On Aug 26, 7:37 am, Vivek wrote: Actually the file contains texts with frequent use of TAB and delimiters,it's not a simple MSword document(.rtf). |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conversion of MS word document to MS excel Sheet
Good to hear. Thanks for the feedback.
Gord On Tue, 26 Aug 2008 23:00:00 -0700, Vivek wrote: 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 "JP" wrote: 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 On Aug 26, 7:37 am, Vivek wrote: Actually the file contains texts with frequent use of TAB and delimiters,it's not a simple MSword document(.rtf). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
word pad file conversion to excel sheet | Excel Worksheet Functions | |||
how to convert excel sheet to a word document | Excel Worksheet Functions | |||
how to add excel sheet in word document as an appendix | New Users to Excel | |||
Want to insert Excel sheet in Word document - comes out too big. | Excel Discussion (Misc queries) | |||
Getting specific data from a word document into an excel sheet | Excel Worksheet Functions |