Hi, I have a spreadsheet that already has data in it. I want a macro to remove any data from the spreadsheet where the cell exceeds 35 characters in length.
I thought Data -> Validation might help but as the data is already in the spreadsheet it does not.
Any help would be appreciated.
I thought Data -> Validation might help but as the data is already in the spreadsheet it does not.
Any help would be appreciated.