I have an excel sheet with a few thousand rows of something similar to the following:
A1 B1
9-1 Apple
9-2 Pineapple
10-1 Grape
10-2 Orange
10-3 Pear
11-1 Lemon
Is there a VBA script that can delete the rows which contain anything other than a "-1" after the number? So the result should look like this:
A1 B1
9-1 Apple
10-1 Grape
11-1 Lemon
The number of variations for each first digit varies. Sometimes it can be only 1, while other times it can be up to 8 or 9. Just need to keep the "-1" of every row and delete the rest.
Many thanks in advance.