Converting data from PDF list to Excel. HELP!

[CMG32]

I'm working for a campaign and we have an invite mailer going out. I was told to get the list to the girl handling everything with the printers. Of course, last minute, I realized that the Voter Vault list was PDF and I want to make it easier for the household names/addresses to be used by the printer so I wan tto put it in Excel. I'd like to have this done BEFORE the sun comes up hopefully. We have over 2500 mailers going out and I do not have the time or energy to do these all manually. I found this site while googling for help and you guys seem incredible smart in this, so I'm crossing my fingers its a quick and painless process, if not then at least a shorter process than manually reentering.

Here's what the original PDF list looks like:

and here is what it looks like when i attempt to paste it (i knew it wouldn't turn out right, but just to aid in visualizing)

Any little things you think may help or little tidbits of advice are greatly appreciated. I am praying there is an answer of some kind!

 

[diddi]

there is a useful program which can help you. pm me for details as advertising is generally not considered good etiquat here at mrexcel. i have no affilliation with the program and do not benefit from its distrubution

 

[Michael M]

Hi CMG and welcome to the Board
It's easy, but you have to pay for it. There are heaps of Free trials websites but they usually only do one page. You basically need to buy the UnPDF software.

 

[diddi]

well maybe you don't MM

best get a game in before the heat wave i think

 

[John Davis]

I'm working for a campaign and we have an invite mailer going out. I was told to get the list to the girl handling everything with the printers. Of course, last minute, I realized that the Voter Vault list was PDF and I want to make it easier for the household names/addresses to be used by the printer so I wan tto put it in Excel. I'd like to have this done BEFORE the sun comes up hopefully. We have over 2500 mailers going out and I do not have the time or energy to do these all manually. I found this site while googling for help and you guys seem incredible smart in this, so I'm crossing my fingers its a quick and painless process, if not then at least a shorter process than manually reentering.

Here's what the original PDF list looks like:

and here is what it looks like when i attempt to paste it (i knew it wouldn't turn out right, but just to aid in visualizing)

Any little things you think may help or little tidbits of advice are greatly appreciated. I am praying there is an answer of some kind!

Is the data when pasted in Column A text?