Deletion of columns based on criteria? RRS feed

  • Question

  • Recently, I made a PDF extractor to excel, it uses Microsoft word to copy and paste the data from PDF

    I encountered a problem where by the data extracted is dirty due to the data in the PDF.

    So I was thinking of how to code a criteria where by it checks a Certain column (Column "D") and if there are less than 2 characters in the cells, delete the cells and shift the rest of data to the left.

    Are there such checks?

    Appreciate the help!

    Tuesday, August 8, 2017 6:47 AM

All replies

  • There is no check to do this.  You can write a VBA routine to do it.  I had to do something similar to this when extracting an insurance appraisal from PDF to Excel.  I extracted the PDF info to a text file.  The routine read the text file, split the columns and populated a spreadsheet ignoring certain values.
    Tuesday, August 8, 2017 2:28 PM