I have this big excel-sheet with a lot of rows and coloumns. I need to delete specific rows, if they contain specific words.
Ex.
I need to delete all rows containing the words "jep" and "elp". Is this possible through either a function or a macro? Is there a way to do it, so it doesnt mess with the format of the other cells, now that there are rows missing? (I have a lot of functions in all of the cells)
A B C D E F G H I J
1 jep
2 jep
3 alp
4 elp
5 felp
6
7
8 felp
9 telp
10 elp
THANKS!
Bookmarks