Posts by Click69

    I have a spreadsheet with a large number of product codes that include eight now redundant characters. I am trying to create a macro to pass down a column and delete the first eight characters in each cell. This is an example of the data I am working with.

    5104001 0175V359
    6010001 0179V498
    6010001 0179V499
    3807110 0185V158
    5430000 0186V133
    3807085 0191A001AA

    Anyone any idea how to approach this?