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

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.

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

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

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

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

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

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

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