An application at work convert data [mostly name & addresses] into a word document in table format. There is no choice in this matter. I now have 150 word files that I want to convert into one excel spreadsheet, so that i can re-sort it remove the duplicates etc. Is there a quicker way of doing this rather than one by one, convert table to text remove the line feeds copying and pasting?
Excel should be able to retrieve data from most files and put them into spreadsheets, or at least I thought it could. Try making them into an Access database beforehand (better idea anyway really) either from the word files or from the plain text, and then you should be able to export to an Excel spreadsheet.
tomd - thanks, but as I mentioned in the Q, there is no option, the programme automatically saves the info into word. Just wondered if there was a shorter way of doing it.