Converting a multi-line pdf to excel

[jeanmarcd]

Hello,
I attach herewith a file which shows the example I am referring to.
I have a pdf file containing multi lines within a cell that when converted still gives me multi lines within a cell.
I need the pdf file to convert to an excel file where each line of the multi-line cell is in its own cell / line.
I hope the example explains it.

Please advise if you can help me.

 

[AlanSidman]

Problem opening file

 

[jeanmarcd]

Hi, my apologies about this...
Please see attached newly generated excel file.

 

[vletm]

jeanmarcd​

Your I need the pdf file to convert to an excel file where each line of the multi-line cell is in its own cell / line.
Could You send a sample PDF-file ... instead of Excel-file?
... as You've written.

 

[jeanmarcd]

Is there any way I can send the file "securely" - i.e. for privacy to be secured?

 

[jeanmarcd]

Hi, See attached pdf which is the pdf I am trying to convert to excel and get the correct results (i.e multi lines to be split into their own lines)

 

[jeanmarcd]

Hello,
I have not had a reply to my previous message above.
Please advise.

 

[vletm]

jeanmarcd​

You gotta learn to wait
or
You gotta learn to sell Your thread ( that others would be more interesting about it ).
My Excel won't import PDF's.

 

[jeanmarcd]

jeanmarcd​

You gotta learn to wait
or
You gotta learn to sell Your thread ( that others would be more interesting about it ).
My Excel won't import PDF's.

Thank you very much for your reply.
Having had no response to my last post I was wondering what was the status quo.

 

[pecoflyer]

Tried to import with Power Query, here is what it returns... Strange

 

[DJunqueira]

The same for me.

 

[jeanmarcd]

Thanks everyone.
I believe the initial issue is to do with the excel output I get from the pdf converter software.
We can close this thread.
Thanks for those who tried to help.

 

[vletm]

jeanmarcd​

• When drafting a question, try and lay out the question in a clear and concise way.
• Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
• Don't leave out information more info is better

If You've solved the way to Excel-file with some thing,
then the rest of converting should be possible to do.
Your given sample has one row data.
You should able to send more realistic sample file eg 10 rows data as well as write - how many rows there are normally?
Can required excel conversion output show in other sheet?
or
Could this solve eg with VBA?
... then it should be possible to do with same sheet.