Skip to main content
Participant
February 25, 2017
Question

How to copy data from PDF credit card statement to excel without all the formatting, logos etc

  • February 25, 2017
  • 2 replies
  • 3183 views

I want to export the date, descriptions and amounts from a credit card statement into excel. However, when I attempt to do so it brings with it all the formatting lines, logos and unnecessary symbols etc.

I then have to go through the copied data and delete all the unecessary data along with deleting rows to get it all to line up as it does on the actual pdf.

    This topic has been closed for replies.

    2 replies

    Legend
    February 25, 2017

    Try copy then Edit > Paste Special. some of the text options might work better.

    Legend
    February 25, 2017

    Do you use copy/paste or export/open or something else?

    Participant
    February 25, 2017

    i used export and copy seemed to produce a similar resul.