Pasting data from pdf to Excel

[alwaysajewell]

I have a pdf form that is required by law to be filled out by others with names and addresses and other info. The form has ten fields for names and ten fields for addresses. I need the names to be imported into Excel to make name badges. When I import the data into Excel, all the information goes into one row. I need the names to go into one column. At times we would get 800-900 names that need to be imported, so I need to do this to avoid entering them myself in Excel.

 

[Desu Nota from Columbus]

http://www.pdftoexcelonline.com/

Would this work?

 

[Desu Nota from Columbus]

If this doesn't work for you, can post an example of how the names are separated inside A1?

For instance:

A1= Christian Bale, Jim Carrey, Harrison Ford, Johnny Depp, Zachary Quinto

vs

A1=
Jessica Alba
Jessica Biel
Jessica Simpson
Jennifer Lopez
Scarlett Johansson

 

[alwaysajewell]

Unfortunately, the converter did not work. No data was transferred to Excel. When I export from the pdf, the data saves as an xml which I save, then import into Excel. In Excel, A1 has a birthdate, B1 has a name, C1 has a birthdate, D1 is an address, E1 is a name, F1 is another name, G1 is a name, and so on down the row. I tried copying this row and pasting it in a column, which worked, but I have names and all the other data. Could I write a macro to delete what I don't want somehow? I'm not familiar with writing macros. Thanks for your help.

 

[Bravo2003]

Is it not just able to convert 'Text to Columns' in Data?

 

[alwaysajewell]

Text to Columns doesn't work either. I think this is a question for Adobe Acrobat. Thanks for the suggestions.