I have bank statements that I've scanned and am trying to export the individual transactions to an excel sheet so I can summarize expenses over multiple statements. I do the OCR recognition on the scanned pdf page and then export to excel but it puts all of the information for each transaction into one cell instead of breaking out the columns of each transaction. I have tried running text to columns in excel but there are so many problems with inserted spaces and non-fixed length cells that it is more work than just manually entering the info.
I've also tried enlarging the transactions only on the statements and highlighting only the transactions to copy and paste into xcel but same issue happens. Is there a trick to getting PDFELement to recognize the columns in the statement?