Re: Convert pdf to xl using adobe acrobat
The attached solution takes over after you use something like pdf2txt to get the data out of the .pdf and into Excel. It works for the number part of your problem. It assumes that the delimiter between numbers is a space. It handles up to four columns of numbers, but has instructions to expand that.
What it does is concatenates all of the fields into one string, then eliminates the extra spaces with a trim and replaces the "(" with a "-" and eliminates the ")" and "," with nested substitutes. It then separates the remaining number text into separate cells and converts them to values.
The label part of your problem, if delimited with spaces, cannot be fixed automatically unless there are patterns that can be evaluated.
I hope this helps.
Video Tutorials / Excel Dashboards Reports