Google Sheets: How to Filter for Cells that Contain Text


You can use the following syntax to filter for cells that contain certain text in Google Sheets:

=FILTER(A1:C17, REGEXMATCH(A1:A17, "East"))

This formula filters the cells in the range A1:C17 to only return the rows where cells in the range A1:A17 contain the word “East”.

You can also use the following syntax to filter for cells that contain one of several values in Google Sheets:

=FILTER(A1:C17, REGEXMATCH(A1:A17, "East|West"))

This formula filters the cells in the range A1:C17 to only return the rows where cells in the range A1:A17 contain the word “East” or “West”.

The following examples show how to use this syntax in practice.

Example 1: Filter for Cells that Contain Text

Suppose we have the following data in Google Sheets:

We can use the following formula to filter for rows where the Region is equal to “East”.

Notice that only the rows where the Region is equal to “East” are returned.

Example 2: Filter for Cells that Contain One of Multiple Texts

Once again suppose we have the following data in Google Sheets:

We can use the following formula to filter for rows where the Region is equal to “East” or “West”:

Notice that only the rows where the Region is equal to “East” or “West” are returned.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

How to Sum Filtered Rows in Google Sheets
How to Filter Multiple Columns in Google Sheets
How to Use SUMIF with Multiple Columns in Google Sheets

Leave a Reply

Your email address will not be published.