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 )

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.

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.

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

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

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

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).

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

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).

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).