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?