Transferring tabular data from PDF to Excel, how to make cells not split?

Question

excel

Such a task is worth it, there are bank statements in tabular form, the name of the company and the TIN are of interest from it, these data are in one cell. I am also interested in the corresponding payment from this company.



I tried to convert pdf to word, then copied the data and pasted it into excel. Here's what happened:



it scatters into different cells. How can this problem be solved? maybe there is a program that extracts data according to a certain algorithm?

Answer 1

ps2txt + regular expression discarding garbage = information.
Yoksel and "converters" from PDF => trash can.