• Select all your data by pressing Ctrl+A
  • Press Ctrl+F to open Find dialog box

  • Type the text that you want to delete
  • Click Find All button

  • Click on one of the results that appear below the search box, then press Ctrl+A to select all

  • you can see all the rows are selected, now close the Find and Replace dialog 
  • Go to the Home - Delete - Delete Sheet Rows


  • Done