How to Delete All Rows Containing Specific Text Within a Column in Google Sheets?

Google Sheets is a robust and adaptable spreadsheet programme that provides a wide range of features and capabilities to aid in managing and analysing data. Data manipulation tasks frequently include removing rows based on predetermined criteria. In this article, we'll concentrate on a single scenario: removing all rows from a column that contain a particular text.

We'll assume that you have a fundamental understanding of Google Sheets and its user interface throughout this lesson. To ensure clarity and simplicity of comprehension, we will offer step-by-step instructions along with screenshots. So let's get started and discover how to delete rows in Google Sheets that include a particular text within a column!

Delete All Rows Containing Specific Text Within a Column

Here we will first add all the script to the sheet, then run it to complete the task. So let us see a simple process to know how you can delete all rows containing specific text within a column in Google Sheets.

Step 1

Consider a Google Sheet where you have required data.

First, click on Extension and select App Script.

Extensions > App Scripts

Step 2

Then replace the code with the below code −

Code

function deleteRows() {
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var s = ss.getSheetByName('delete containing');
   var r = s.getRange('C:C');
   var v = r.getValues();
   for(var i=v.length-1;i>=0;i--)
      if(v[0,i]=='Complete')
         s.deleteRow(i+1);
};

In the code, “Sheet1” is the sheet name the sheet name, and “No” is the text.

Step 3

Then run the code to complete the task.

Then you will see that rows will be deleted. This is how you can delete all rows containing specific text within a column in Google Sheets.

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can delete all rows containing specific text within a column in Google Sheets to highlight a particular set of data.