Calc - Searching and Deleting Cells

[Bedsheets]

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.

[Lupp]

Please tag your question correctly and rectify the subject. The question is not about the ‘Math’ component (for editing and rendering of mathematical formulas) but about ‘Calc’ (spreadsheets).

[Lupp]

You cannot delete cells.
You can delete rows. You can delete columns. You can delete cell contents.

In all these cases you first have to select the range to which the operation should be applied (if not to the complete sheet).
Then:
-1- Open the ‘Find & Replace’ dialog.
-2- Show ‘Options’
-3- Enable ‘Regular expressions’
-4- Enable ‘Current selection only’ (If wanted).
-5- Enter the character string .*(-|[0-9]).* into ‘Find:’. (It’s a regular expression.)
-6- Leave ‘Replace:’ empty.
-7- Click on ‘Find All’.

The next step depends on what you actually want to delete.
Cell contents: Close the ‘Search results’ windowlet, press the ‘Del’ key.
Complete rows: Rightclick one of the highlighted cells, choose ‘Delete…’, choose ‘Delete entire row(s)’.
Complete columns: Respecticvely