I am using Excel 2007. I have a bunch of .pdf files that I need to take a building address, city, and ZIP from and paste into excel. Google searching proved fruitless for what I need. Here is what the excel sheet looks like:
Very simple set up. But here are what the files look like that I need to get the data from:
All I need are those three columns. Copy pasting is ridiculously time consuming, I've been doing the manual entry thing, also slow, I have ~9,000 entries all total to do. I saved as a .txt and tried to import, didn't have much luck. HELP!!!
I know there has to be an easy way to get this done. I have to be done with this Tuesday at 5pm CST.
![excelexample.png](/board/proxy.php?image=http%3A%2F%2Fimg.photobucket.com%2Falbums%2Fv381%2FdavidB382%2Fexcelexample.png&hash=199922aa945072d193df5e5df9ba4460)
Very simple set up. But here are what the files look like that I need to get the data from:
![pdfexample.png](/board/proxy.php?image=http%3A%2F%2Fimg.photobucket.com%2Falbums%2Fv381%2FdavidB382%2Fpdfexample.png&hash=41eb20a930a59afa244e1853bf010f92)
All I need are those three columns. Copy pasting is ridiculously time consuming, I've been doing the manual entry thing, also slow, I have ~9,000 entries all total to do. I saved as a .txt and tried to import, didn't have much luck. HELP!!!