Hi all,

I have a spreadsheet, with about 1,500 lines. In column A is a list of numbers that I need to remove the last 8 digit from each number, for example in A22 is 123456700000000 - I need this to be 1234567. The numbers are all not uniqe.

How can I remove the last 8 digits from every number, without going in manually to do so?

Thank you!