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.
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.