How to transfer data from PDF to spreadsheet efficiently

[jpbranson]

I'm looking for help transferring data from a PDF to Excel (the PDF link will be at the bottom of this post). Specifically, I need to get addresses from this document, so, three lines of text into four different cells. I don't need to include the state, but I do need to separate city and zipcode; see below for example.

The PDF is set up as a table, but when copying full pages of it into Excel, everything goes to one column. To complicate things further, the pages do not all follow an identical pattern.

Right now, I'm just manually copying and pasting each cell, but I trust the Excel gods (or demons) that there must be a more efficient way to do this.

This is the link to the PDF document: http://www.dbcf.state.ms.us/documents/lists/checkcasher.pdf

To give an example of what I'm doing, the first row of my spreadsheet reads as follows: Kroger Limited Partnership I d/b/a Kroger, 1617 Delaware Ave, Mccomb, 39648
(commas represent cell separation)

I am on a Mac, so if anyone has any advice on how to use Automator or AppleScript to help, that'd be much appreciated.

Finally, I am very inexperienced, with no experience in VB or code in general, so please take that into account.

 

[Vantiro]

I've had some luck copying informaton to a word document first and then to excel, but it hasn't worked everytime. Worth a shot though.

 

[jpbranson]

That has helped a little (mostly by being able to select entire lines with one click), so thanks.