I am trying to delete certain rows on excel based on certain words. So for example, there are some cells that contain the word sum: and then an amount. I cannot figure out how to delete the row. The only option is to delete the specific word, however, the number remains and the only way I can delete the number is to do it by hand since the excel worksheet is very lengthy.
Solved by M. J. in 19 mins