Quizzes & Puzzles2 mins ago
Importing Word data into Excel
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.
Answers
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.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 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.