Importing Word text into rows and columns

[Pualy]

I want to copy some data from ms word into multiple cells of an Excel worksheet. If I just cut and paste the data simply goes into one cell. Not good. Additionally, I want the data to be copied into the worksheet as numeric format so I can do calculations on it.

Any help would be greatly appreciated.

[Paul]

Hi Pualy, and welcome to the forum.

I haven't tried this myself, but perhaps this post will come close to what you need. It refers to RTF files, but you should be able to change RTF to DOC (hopefully!).

http://www.excelforum.com/excel-prog...-to-excel.html

[martindwilson]

you should just be able to open the word doc using excel then use the various delimited options to get the result you want