Donate SIGN UP

Importing Word data into Excel

Avatar Image
Gandy | 22:29 Tue 07th Dec 2004 | Technology
2 Answers

Right then, I'm not at all sure that this is possible, but laziness dictates that I must try.  I have 600 fax templates saved in word (.doc) format.  I need to extrapolate certain data e.g. recipients name, phone number and fax number into excel to use as a database sheet.  I have done 6 so far by copy/pasting the table that contains this data from the word docs into ecel and then reformatting the data manually.  As Natwest would have be believe "surely there is another way?"  Any help would be much appreciated. 

Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by Gandy. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Try saving the Word (.doc) file as a text file instead, and then open that text file from Excel.  It should then give you the option to format it into something useable.
further to meta's answer I would copy several into one word doc and then do a search and replace for carraige returns etc so that you have the address in the format:

1 the road, town, county, postcode

all on one like in the word doc.
save the file as a text file, change the extension to .csv and then import it into excel and it will be preformatted for you.

1 to 2 of 2rss feed

Do you know the answer?

Importing Word data into Excel

Answer Question >>

Related Questions