I may be asking spreadsheet software to do things it’s not supposed to so thought I’d check here.
I have huge spreadsheets that I have to cut down to size to make them manageable. All cells are just simple text. Firstly, I need to eliminate all cells that have a hyphen in them as this means there was an error in the test. Each sheet contains about 5000 cells and there are roughly 200 sheets per spreadsheet. I can search for ever instance of a hyphen ‘-’ across sheets but is there any way to delete them all at once? Even if I could just highlight them all that would help a little.
Similarly I need to delete all cells with numbers in them as these indicate duplicates. A cell should contain QbdyuiUnvcpoIJYbhjk for example and I need to get rid of cells which look like Qbdyui86vcpoIJYbhjk since it contains a number and also any containing hyphens such as Qbdyu-Unv-poIJYbhjk
It may be that I need to use Libre’s database software or something similar but any guidance would be much appreciated.