Yes. In Excel for Microsoft 365 on Windows, open the column’s filter menu and choose Text Filters > Contains, enter the word or fragment, and select OK. Excel then shows rows whose cell text contains that fragment, even when it appears in the middle of a longer entry.
What a partial-text filter does
An Excel filter temporarily hides rows that do not meet a condition; it does not delete the underlying data. A contains filter checks the text in one column and keeps rows where that text includes the characters you specify. For example, filtering a Product column for mug can show entries such as Travel Mug, Mug Set, and Ceramic mugs, while hiding unrelated products.
The match can appear at the beginning, middle, or end of the cell. That is what makes Contains different from Begins With and Ends With. It is useful when the text you need is only part of a longer label, name, address, product code, or note.
Filtering works on the values shown in the cells. If a cell contains a formula, Excel filters according to the formula’s result, not the formula text. For example, a formula that returns North Region can match a search for Region, even though the formula itself may refer to other cells.
How to filter for text that contains a fragment
For a normal list with a header row, follow these steps in Excel for Microsoft 365 on Windows:
- Click a cell in the data range. Make sure each column has a clear header and that the range does not have an unintended blank row separating the data.
- On the ribbon, select Data > Filter. Filter arrows appear in the header row.
- Select the arrow in the column you want to search.
- Point to Text Filters, then select Contains.
- Enter the fragment in the filter dialog and select OK.
The remaining visible rows are those with a match in that column. To see the entire list again, open that column’s filter menu and choose Clear Filter From followed by the column name. To remove filters from the range, use Data > Clear. Clearing a filter restores hidden rows; it does not alter their contents.
If your data is an Excel table, the header filter buttons are usually already available. Otherwise, you can create a table by selecting a cell in the range and choosing Insert > Table, then confirming whether the range has headers. Tables are helpful for ongoing lists because their filter controls and formatting can extend as rows are added.
Use the filter menu search box for a quick match
The filter dropdown also has a search box above its list of distinct values. Type a word or fragment there to narrow the displayed choices, then select the matching value or values and confirm the filter. This is often the fastest approach when you know what text to look for and want to select existing entries directly.
The search box and the Contains condition are related, but they serve slightly different purposes. The search box narrows the checkbox list of values so you can select specific entries. Text Filters > Contains applies a text condition to the column. For example, the search box can help you select a particular set of product names, while Contains is a clear choice when you want every cell that includes a specified fragment.
When a column contains many unique values, the search box saves scrolling. Check the selection before applying it: Excel filters the rows represented by the selected values, and an accidental selection can make it appear that some matching records are missing. If the list is hard to manage or you need a reusable rule, use the Text Filters command instead.
Examples of useful partial-text filters
A short fragment can find variations without requiring you to type every complete value. Suppose a Department column contains Sales – East, Sales – West, Support, and Customer Success. A contains condition for Sales returns both Sales entries. A condition for East returns Sales – East even though East is not at the start of the cell.
Other practical examples include:
- Search a full-name column for a surname, such as Chen, to find names that include it.
- Search an email or web-address column for example.org to show addresses from that domain.
- Search an item-code column for R-4 to find codes that include that sequence, wherever it appears.
- Search a notes column for overdue to review records whose notes mention that word.
Choose a fragment distinctive enough to avoid unrelated matches. Searching for a very short sequence such as on may match many words and codes. If the results are too broad, use a longer fragment or combine conditions.
Case sensitivity, spaces, and wildcard characters
Excel’s standard text filters are not case-sensitive. A contains search for north can match North, NORTH, or north. If capitalization matters, the filter menu alone is not the right tool; you would need a separate case-sensitive check, such as a helper column using an appropriate formula.
Spaces are characters too. If you search for Blue mug, that phrase includes the space between the words, so it will not match a cell containing Blue-mug or Blue mug with two spaces. If you are unsure how the source text is entered, try a shorter fragment first, then inspect the matching cells.
Excel’s filter criteria can use wildcard characters: an asterisk represents any number of characters, and a question mark represents one character. A tilde can escape a wildcard when you need to search for the literal character rather than use it as a pattern. This is useful for unusual text such as an item name that actually includes an asterisk. For an ordinary word or fragment, enter the text normally in the Contains dialog; you do not need to add asterisks around it.
For more complex rules in one column, use Text Filters > Custom Filter, where you can set two conditions and choose whether both must be true or either may be true. For example, you might include cells that contain East or contain Central. Separate filters on different columns work together, so a text condition in one column and another condition in a second column narrow the rows simultaneously.
Common problems and how to fix them
If Excel returns no rows, first check that the fragment is actually present in the cell values. Extra spaces, punctuation, hyphens, or a spelling variation can change the match. Try a shorter distinctive fragment and verify whether the data is stored as text. Also check that the filter is applied to the intended column and that no other active filter is excluding the rows you expect.
- No filter arrows appear: Click inside the list and select Data > Filter. Check that the data has a header row and that a blank row has not split the range.
- Some rows seem to be missing: Look for active filters in other columns. A row must satisfy all active column filters to remain visible.
- The filter options look different: Excel may treat the selected column as numbers, dates, or another data type rather than text. Choose the corresponding filter options, or check whether the cells contain consistent text values.
- The search list does not show the expected entry: Clear other filters, then reopen the dropdown. The list may reflect the currently visible records rather than every value in the full dataset.
- New rows are not included: Check whether the filter range covers them. Adding data to an Excel table generally makes it easier for the table range to grow with the list.
Filtering can also make a worksheet look as though data has disappeared. The rows are hidden from view, not removed. Use the column’s clear-filter command or Data > Clear to restore the view. Avoid deleting visible rows unless you truly intend to remove records from the worksheet.
When to use a filter, a formula, or Find
Use a column filter when you want to inspect a subset of rows in place and interact with the worksheet. It is quick, reversible, and suitable for sorting through a list. Use the filter dropdown’s search box when selecting a few known values; use Contains when you want a text-based rule that includes matching fragments throughout the cell.
Use Find when you only need to locate occurrences rather than hide nonmatching rows. The Find command searches worksheet contents and can be useful for jumping between occurrences. A filter is usually better for reviewing all matching records together or copying a visible subset for further work.
A helper column or a dynamic-array formula can be more suitable when the result needs to appear in a separate area, feed another calculation, or be reused as part of a larger workflow. Those options require more setup and can behave differently depending on the data and Excel version. For a one-time review of a list, the built-in filter is usually simpler.
Frequently Asked Questions
Can Excel filter text that appears anywhere in a cell?
Yes. Open the column dropdown and choose Text Filters > Contains. The fragment can appear at the start, middle, or end of the cell value.
Is Contains different from Begins With?
Yes. Contains matches the fragment anywhere in the text. Begins With only matches when the cell starts with that fragment; Ends With only matches when it finishes with it.
Does Excel’s partial-text filter distinguish uppercase and lowercase?
No. Standard Excel text-filter matching is not case-sensitive, so capitalization differences do not prevent a match.
Can I filter for either of two partial-text phrases?
Yes. Open Text Filters > Custom Filter, enter the two conditions, and select the option that matches either condition. Choose the both-conditions option if a row must include both phrases.
Does filtering delete rows that do not match?
No. It hides rows from the current view. Clear the filter to show them again; the cell contents remain in the worksheet.
Why does a contains filter show no results?
Check spelling, punctuation, spacing, the selected column, and any other active filters. A shorter fragment can help determine whether the text differs from what you expected.
Related
- Excel Data Validation List: How to Exclude Blanks in Excel
- Excel Data Validation List From Another Sheet: Steps
- Excel Data Validation List From a Table Column Explained
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- SUMIF Excel Cell Reference: Syntax, Examples, and FixesWith criteria in A2:A6 and amounts in C2:C6, enter =SUMIF(A2:A6,"North",C2:C6) to add the amounts for rows marked North;…
- Excel Filter Dates Within a Range: Steps and FixesTo filter Excel dates within a range, select a cell in your data, choose Data > Filter, open…
- Box Plot Formula: Quartiles, IQR, and WhiskersA box plot has no single formula: it is built from a five-number summary—minimum, first quartile (Q1), median,…
- Excel Text Comparison Formula: Exact vs. FlexibleTo compare two cells in Excel, use =A2=B2; it returns TRUE when their contents match and FALSE when…
- EDATE in Excel: Add Months to a Date, With ExamplesTo add calendar months to a date in Excel, use =EDATE(start_date, months). For example, with a date in…
- How to Add a Sequence of Dates in Excel: 3 Easy WaysTo add a sequence of dates in Excel, enter a starting date and the next date in two…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.