I orginally had a horrible pdf file with a bunch of tables and information on it. As seen in the standard pdf picture
I then used PDFZilla to convert the pdf to a text file. The output can be seen in sampletext.
Then this is where my problem is...
when ever i try to import the text file into excel, I have lots of trouble to get it to format correctly. I try text to columns but i cant get it to separate the numbers correctly.
I don't care about the column headers, but I do need the row data to be separate so that I can write a macro to extract the data and then copy it to another workboook.
Please help! I hope that I have provided enough explanation.