Large text file of address in word, import into excel
Basically i have a large document in word, with a huge number of names, addresses and telephone numbers. I want to import all these details into corresponding fields into excel (name, address, tel, postcode) etc.
copying and pasting is an option, but there must be an easier way!
most of the data is seperated by a commas. I tried saving it as a text document and importing it into excel that way and its about 50% accurate, with half the stuff in the wrong cells.
Here's an example:
Contract Services, Suite 2, Ground Floor, Jimbo House, 29 LOL Street, INVERNESS, IV1 1xU, Tel: 01962 244490, Fax: 01363 221188, Email: firstname.lastname@example.org
What seems to be causing the problem, is if a company has a an additional piece of info and others dont. If one company has building name or what ever, it seems to be moved across to the next cell. The business addresses vary from just a simple address down to fully blown out with rooms, buildings etc. The number of addresses in this file is around 5k, so im looking at an easy method of sorting!
Someone mentioned putting in additional comma in place of the missing info, I havent tried this yet, any suggestions?
Its mostly 3 lines per record, including the business name, which in its self is a hyperlink (though not really important). Although depending on the length of the details, it can span onto 4 lines per record.
Contract Services, Suite 2, Ground Floor, , 29 LOL Street, INVERNESS, IV1 1xU, Tel: 01962 244490, Fax: 01363 221188, Email: email@example.com
Extra new line (no space between records) seperates each record.
All telephone numbers, fax and email address are prefixed.
Is there somewhere to go to get a quick script made for this? I would be prepared to pay up to £50 for it to be done asap. (This weekend hopefully)!