Excel Filter by Partial Text: How to Find Matches

Formulas & functions · Updated November 19, 2026

To filter Excel rows by text found anywhere in a cell, select a cell in your data, choose Data > Filter, open the column’s dropdown, then choose Text Filters > Contains and enter the text. For a quick search, you can also type part of the text into the dropdown’s search box and keep the matching results selected.

How the standard text filter works

Excel’s AutoFilter hides rows that do not meet your criteria; it does not delete or change the underlying data. The Contains option looks for the characters you enter within the selected column’s cell values. For example, if a Product column contains “Blueberry Muffin,” “Muffin Tin,” and “Blueberry,” filtering for “muffin” returns the first two rows. The matching text does not have to appear at the beginning of the cell.

To apply this filter in Microsoft Excel for Microsoft 365 on Windows:

  1. Click a cell inside the data range. Make sure the columns have clear headings and that there are no completely blank rows splitting the data.
  2. Choose Data > Filter. Excel adds a dropdown arrow to each heading. You can also use Home > Sort & Filter > Filter.
  3. Open the dropdown for the column you want to search.
  4. Choose Text Filters > Contains. Enter the partial text in the dialog, then select OK.

To remove the condition, open that column’s dropdown and choose Clear Filter From, followed by the column name. To turn off all filter arrows, choose Data > Filter again. On Mac, the Filter command is also on the Data tab; the wording and layout of the dropdown can vary slightly by Excel version. Excel for the web offers filtering from the column dropdown as well, though its interface may differ from the Windows desktop app.

Contains, Begins With, and Ends With

Text Filters includes several related choices. Pick the one that reflects where the characters must appear:

  • Contains: Finds the entered text anywhere in the cell. Searching for “road” can match “Oak Road” and “Roadside Market.”
  • Does Not Contain: Keeps rows whose cell values do not include the entered text.
  • Begins With: Finds values that start with the text, such as “INV” in invoice numbers like “INV-1042.”
  • Ends With: Finds values that finish with the text, such as “.org” in website addresses.
  • Equals: Matches the entire cell value rather than a substring. Use it when you need an exact value.

These distinctions prevent a common error: choosing Equals when you mean to find a word inside a longer entry. If you want “North” to match “North warehouse,” use Contains, not Equals. The text filter normally ignores capitalization, so a search for “north” can match “North” and “NORTH.” If capitalization must determine the result, use a formula-based approach with the case-sensitive FIND function rather than relying on the standard filter dialog.

Use the filter dropdown’s search box

The dropdown search box is convenient when a column has many distinct values. Open the column arrow and type a word or fragment in the search box. Excel narrows the list of values shown in the dropdown; select the matching values you want included, then apply the filter if necessary. This is especially useful when you want to select a few known entries from a long list without opening the Text Filters dialog.

There is a useful distinction between searching the dropdown list and setting a Contains condition. The dropdown search helps locate values in the list of distinct cell entries, and you can check or uncheck the results. Text Filters > Contains instead expresses a condition on the column’s text. If you are unsure whether selecting search results has preserved the intended values, reopen the dropdown and review the checked items. For one partial phrase across many rows, Contains is often easier to interpret; for a handful of specific entries, the search box can be quicker.

Filter with wildcard characters

For more flexible criteria, Excel’s filter criteria can use wildcards. An asterisk (*) represents any number of characters, while a question mark (?) represents one character. A tilde (~) before a wildcard treats it as a literal character. For example, a criterion such as *berry* can match text with “berry” anywhere in the cell, while AB-?? can match a value beginning “AB-” followed by exactly two characters.

Wildcards are most useful when you need a pattern rather than a simple substring. In a Text Filters custom condition, enter the pattern as the criterion and inspect the results to confirm it behaves as intended. Excel also uses wildcard matching in other contexts, but the way a particular dialog accepts criteria can differ, so use the filter’s built-in Contains option for a plain phrase and reserve wildcards for patterns. If you need to find a literal asterisk or question mark in the data, prefix it with a tilde; otherwise Excel may treat it as a wildcard.

Use a helper formula for more control

A helper column is a good choice when you want a repeatable test, need to combine the result with other conditions, or want to filter on a match that the dropdown cannot express conveniently. Suppose the text to look for is in F1 and the values to inspect are in A2:A100. In B2, enter the formula below and fill it down through the rows. It returns TRUE when the value in A2 contains the text from F1, and FALSE otherwise:

With the search term in F1 and the source text in A2, use =IF($F$1="",FALSE,ISNUMBER(SEARCH($F$1,A2))). If F1 contains “maple” and A2 contains “Maple Street,” the result is TRUE. The formula deliberately returns FALSE when F1 is blank, rather than treating every row as a match.

SEARCH is case-insensitive and returns the position where it finds the text; ISNUMBER converts a successful search into TRUE. After copying the formula down, turn on filters and filter the helper column to TRUE. The helper column makes the logic visible and can be adjusted—for example, by combining tests—without changing the original text. If the search term may contain wildcard characters and you intend those characters literally, be aware that SEARCH treats * and ? as wildcards; the normal Text Filters Contains dialog may be simpler for a literal phrase.

Choose the right method and understand its limits

Use the built-in Contains filter for a straightforward substring search in one column. Use the dropdown search box when your aim is to find and select particular distinct values. Use a helper formula when the match must be reused, combined with other tests, or displayed as a separate TRUE/FALSE result. A formula does not replace AutoFilter: it creates a result column that you can then filter.

Standard AutoFilter conditions apply to one column at a time, but you can filter multiple columns together. Excel combines filters on different columns with AND logic: for instance, a City value containing “port” and a Status value equal to “Open” must both be true for a row to remain visible. Within a single custom text filter, you may be able to set two criteria and choose AND or OR. For more involved logic across multiple columns, a helper column can make the intended test clearer.

Filtering is also different from highlighting. If you want to see all rows but make matching cells stand out, use Home > Conditional Formatting rather than AutoFilter. If you need a separate, automatically updating list of matching rows, Excel’s FILTER function can return one in supported versions, including Microsoft 365 and Excel 2021 or later. That is a different task from hiding nonmatching rows, and its behavior depends on the formula and source range.

Common problems and how to fix them

  • No results appear: Check spelling, spaces, punctuation, and whether you filtered the correct column. A copied value may contain a nonbreaking space or another hidden character that is not obvious on screen.
  • Some matching rows are missing: Check that the entire data range is included in the filter and that the column does not contain mixed data types or unexpected blank cells. Clear existing filters in other columns while diagnosing the issue.
  • The filter arrows do not cover all rows: A blank row or column can cause Excel to detect only part of a contiguous range. Remove the gap or select the complete range before applying Data > Filter. Converting the range to a table with Insert > Table can help keep a structured dataset together as it grows.
  • Numbers or dates are not treated as text: Excel may offer number or date filters instead of text filters when it recognizes the column’s contents as numbers or dates. Check the underlying values and use an appropriate filter type, or create a helper column if you specifically need to search their displayed text.
  • Rows seem to have disappeared: Filtering hides nonmatching rows; it does not remove them. Clear the filter to show them again. Also check whether rows were hidden manually or by another active column filter.

Frequently Asked Questions

Can Excel filter a word that appears anywhere in a cell?
Yes. Open the column dropdown, choose Text Filters > Contains, and enter the word or phrase. The filter returns rows where that text appears within the cell, not only at the beginning.

Is Excel’s partial-text filter case-sensitive?
No, the standard text filter is generally case-insensitive. A search for “oak” can match “Oak” or “OAK.” For case-sensitive matching, create a helper formula using FIND, which is case-sensitive, and filter the resulting TRUE/FALSE values.

Can I filter for two partial words at once?
Use the custom text-filter dialog to set two conditions and choose AND if both must match or OR if either may match. If the conditions involve several columns or more complex logic, a helper column can be easier to check and maintain.

Does filtering delete the rows that do not match?
No. AutoFilter temporarily hides nonmatching rows. Clear the filter to display them again. If you copy only visible cells elsewhere, that creates a separate copy; it does not mean the original hidden rows were deleted.

Can I search part of a number or date?
Excel may treat numeric and date values as numbers or dates rather than text, so Text Filters may not be available for that column. If you need to search the displayed representation, use a helper column that converts values to text in a way suited to your data, then filter that column.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.