Yes. In Excel for Microsoft 365 on Windows, turn on a column’s filter, open its dropdown, and choose Text Filters > Contains to show rows whose cells include a word or fragment. For a separate, automatically updating list of matching rows, use the FILTER function with SEARCH.
Filter a column for text it contains
Excel’s built-in AutoFilter is usually the quickest choice when you want to hide nonmatching rows in the current list. It works on an ordinary range or an Excel table, and it does not delete the rows it hides.
- Click a cell inside your data. Make sure the columns have headers and there are no completely blank rows splitting the list.
- On Windows, press Ctrl+Shift+L, or choose Data > Filter. Filter arrows appear beside the column headings. If your data is an Excel table, it normally has filter arrows already.
- Open the arrow for the column you want to search, such as Product or Description.
- Choose Text Filters > Contains. Type the fragment—for example,
mug—and confirm the filter.
Excel then keeps rows with that fragment anywhere in the selected column’s text. A search for mug can match “Travel mug,” “Mug warmer,” and “mug-blue,” not just a cell that consists of the word alone. To match text at the start or end instead, use the related Begins With or Ends With option. To exclude a fragment, choose Does Not Contain.
In Excel for Mac, use Data > Filter to show the arrows, then use the column dropdown’s text-filter options. Keyboard shortcuts can differ by Mac keyboard and Excel settings, so the ribbon command is the dependable route.
What a partial text match means
A partial match looks for a character sequence inside a cell, rather than requiring the entire cell to equal the search term. For instance, a Contains filter for west can match “West warehouse,” “Northwest,” and “west-side.” That makes it useful for product names, addresses, notes, codes, and other fields where the same word appears in longer entries.
Text filters are not case-sensitive in ordinary use: searching for mug also finds “MUG” and “Mug.” Spaces are characters, however. Searching for mug with a leading space does not mean the same thing as searching for mug, and accidental spaces in source data can make records appear to be missing. A cell containing a number may not behave like text containing the same digits, particularly if the number is displayed with a custom format. If the target is an identifier, it is often safer to store and search it consistently as text.
The filter applies to the chosen column, not to every cell in the row. If “mug” appears in a Notes column but not in Product, filtering Product for “mug” will not find that row. Decide which field holds the information you want to search before applying the criterion.
Use wildcards for flexible criteria
Excel text filters can also use wildcard characters when you need a pattern rather than one fixed fragment:
*represents any number of characters, including none. A pattern such as*mug*describes text with anything before and after “mug.”?represents one character. A pattern such asAB?7can match “ABX7” or “AB27,” but not “AB77” if the pattern’s character positions do not line up.~is the escape character for treating a wildcard symbol as a literal character. For example, use a tilde before an asterisk when the asterisk itself is part of the text you want to find.
For a normal word or phrase, Text Filters > Contains is clearer than entering wildcard syntax. Wildcards are useful for codes with variable characters or when building criteria in a custom filter. Be precise about whether the symbol is meant as a pattern or as literal text: an unescaped asterisk can match many different cell values.
Return matching rows with a formula
Use a formula when you want matching records displayed in a separate area while leaving the original list visible. FILTER returns an array of rows that meet a condition; SEARCH finds the location of one text string inside another, and ISNUMBER turns a successful search into TRUE. These functions are available in Microsoft 365 and Excel 2021 or later.
Assume headers are in A1:C1, records are in A2:C100, product descriptions are in B2:B100, and the search word is typed into E1. Enter this formula in an empty cell outside the source data:
=FILTER(A2:C100,ISNUMBER(SEARCH(E1,B2:B100)),"No matches")
If E1 contains mug, the formula returns the complete rows whose descriptions in column B contain “mug,” regardless of case. If three records match, the results spill into three rows and three columns. Keep the spill area clear; existing values in the way will cause a #SPILL! error. If no records meet the condition, the formula displays “No matches.” An empty E1 can effectively match every text entry, so enter a keyword before interpreting the result.
This formula produces a live result, not an AutoFilter state: the source rows remain where they are, and the displayed list updates when source data or the search term changes. It is handy for reports, but it can return errors if the ranges have different sizes or if the output area is blocked. For a one-time inspection, the dropdown filter is simpler.
Filter for more than one condition
Excel lets you combine criteria, but the meaning depends on where you apply them. Within one column, the Custom AutoFilter dialog can combine two text conditions with AND or OR. For example, a description could be set to contain mug OR contain cup. AND means a value must satisfy both conditions, which is useful for distinct fragments that must both appear in the same cell.
Filters on different columns work together as well. If Product contains mug and Region equals West, Excel shows rows that meet both column filters. This is an AND relationship across columns. If your intended logic is more involved—such as matching a word in either of two columns, or applying different combinations of conditions—a helper column or a formula may be easier to audit than several dropdown settings.
For example, if a search should match either a product description or a note, a dynamic-array formula can combine the two SEARCH tests. With descriptions in B2:B100, notes in C2:C100, records in A2:C100, and the keyword in E1, use:
=FILTER(A2:C100,(ISNUMBER(SEARCH(E1,B2:B100))+ISNUMBER(SEARCH(E1,C2:C100)))>0,"No matches")
The addition treats either successful test as a match; the comparison to zero creates the TRUE/FALSE include array FILTER needs. Ensure all three ranges cover the same record rows.
Choose between AutoFilter and a formula
- Choose AutoFilter for quickly narrowing the current table, checking records, or applying normal contains, begins-with, and ends-with conditions. It is interactive and requires no formula setup.
- Choose FILTER with SEARCH when you need a second, shareable result list that recalculates as the data or keyword changes. It requires a version with dynamic-array support and free space for the results.
- Choose Find when you only need to locate a matching cell rather than hide rows or produce a list. Ctrl+F on Windows opens Find; on Mac, use Home > Find & Select > Find or the Mac keyboard shortcut configured for Find.
One common misconception is that a filter changes or removes the underlying data. AutoFilter hides rows that do not meet the criteria; clearing the filter makes them visible again. To restore all rows, choose Data > Clear, or open the relevant column menu and clear its filter. A filtered view is not the same as deleting nonmatching records, so check the visible row numbers and clear filters before copying or drawing conclusions from a partial list.
Common problems and fixes
- No results appear: Check that you chose the correct column, that the fragment is spelled as it appears in the data, and that the data range includes all rows. Check for leading or trailing spaces, and clear any other column filters that may also be restricting the list.
- The filter arrow is missing: Click in the range and choose Data > Filter. If the range is split by blank rows or the header row was not included, select the complete list and apply the filter again. Converting a well-formed range to a table with Insert > Table also adds filter controls.
- The formula shows #SPILL!: Clear cells in the area where the returned rows need to appear. A dynamic array cannot spill over occupied cells or into certain obstructed areas.
- Numbers or dates are not matching as expected: Filters may treat stored values and their displayed formatting differently from text. Confirm whether the source is a number, date, or text string, and avoid mixing types in the same field when a consistent search is important.
- Matching text is in another field: A column’s Contains filter checks that column only. Filter the correct field, add another condition, or use a formula that checks each relevant column.
Frequently Asked Questions
Is Excel’s Contains filter case-sensitive?
Normally, no. A Contains text filter matches the fragment regardless of capitalization, so oak can match “Oak,” “OAK,” and “oak.” SEARCH in the formula examples is case-insensitive too.
Can I filter for part of a word in Excel?
Yes. Choose the column dropdown, then Text Filters > Contains, and enter the letters or word fragment. Excel keeps rows where that sequence occurs anywhere in the cell.
How do I filter for text that starts with certain letters?
Open the column dropdown and choose Text Filters > Begins With, then enter the starting characters. Use Ends With for a suffix, or Contains when the position does not matter.
Can I match text in two columns at once?
Yes, but an ordinary column filter only searches its own column. Apply criteria to both columns if both must match, or use a formula such as the two-column FILTER example when a match in either column should qualify.
Does filtering delete the rows that do not match?
No. AutoFilter hides nonmatching rows; it does not remove them. Clear the filter to show them again. If you copy results, check whether you are copying only the visible filtered records.
Can I use a partial match in older Excel?
AutoFilter’s Text Filters > Contains option is available in many older desktop versions as well. The FILTER formula shown here requires Microsoft 365 or Excel 2021 and later; older versions can use AutoFilter or other approaches, such as a helper column.
Related
- Excel Essential Keyboard Shortcuts for Everyday Work
- Excel European Number Format: Decimals and Separators
- Excel Subscript Out of Range: Causes and Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel SUMIFS: Sum Values That Meet Multiple CriteriaTo sum values in Excel when several conditions must be true, use SUMIFS. For example, with regions in…
- Excel Showing Formulas but Not Calculating? FixesIf Excel shows a formula instead of its answer, turn off Formulas > Show Formulas or press Ctrl+`…
- How to Find Unique Names in an Excel Column EasilyIn Microsoft 365, you can create a live list of distinct names with the UNIQUE function. With names…
- Excel Filter Multiple Sheets by Criteria: Best MethodsExcel’s built-in Filter command works on one table or data range at a time; it does not apply…
- Compare Two Columns in Excel: Formulas and MethodsTo compare two columns in Excel row by row, enter =A2=B2 in a third column and fill it…
- AVERAGEIF Formula in Excel: Syntax and Practical ExamplesIn Excel, use =AVERAGEIF(range, criteria, [average_range]) to average numbers that meet one condition. For example, with departments in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.