9/1/2023 0 Comments Convert pdf chart to excelThe headers are sitting on two rows instead of one, and they are merged.What follows is just simple steps of COPY and PASTE.Īs you may have noticed, the output is imperfect: (note: you may be prompt to login again) 8) This is what you get! Because it is Word, it communicates with Excel much much better. 5) wow… Word Online is going to convert the PDF to Word for me to edit. If you don’t, you may sign up for one) 2) Upload your PDF file simply by drag and drop 3) Click on the file you have just uploaded 4) Word Online is opened to show you the content of the pdf file. (Note: You should have it already if you have in email account by Microsoft, e.g. 1) Login OneDrive (previous known as Sky Drive) One day, I read an article about viewing PDF file from OneDrive: PDF file we put in OneDrive would be viewed in Word Online… Then I tried to connect the dots… BINGO, that’s the solution although imperfect. There is no simple way for me to re-organize the pasted data back into a table format, not even with Text to Columns as there is no fixed delimiter nor width. See!? Data on different columns were concatenated by space, all in column A. (well, the clip art was added afterward.) Without PDF converter, what I tried to do was COPY and PASTE… as you may already know, there is no luck… The following screen shot shows what I got from COPY and PASTE…. I don’t blame them as I had managed my expectation. I tried a few of them (freebies) but the result was not satisfactory sometimes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |