Yes. In Excel for Microsoft 365 on Windows, choose Data > Filter, open the column’s filter menu, then select Text Filters > Begins With. To match several beginnings, use Text Filters > Custom Filter and join two conditions with Or; for more than two prefixes, use Advanced Filter or a helper-column formula.
What “Begins With” means in Excel
A begins-with filter keeps rows where the selected column’s text starts with a particular sequence of characters. If a product column contains “Apple,” “Apricot,” “Banana,” and “Cherry,” filtering for “Ap” keeps Apple and Apricot. The characters can be a word, a short code, or even one letter. The filter checks the start of the cell’s contents, not whether the text appears somewhere inside it.
Excel’s ordinary AutoFilter menu is designed for quickly narrowing a list. Its Begins With option accepts one starting value at a time. A Custom AutoFilter can express two conditions for the same column and combine them with AND or OR. That makes it suitable for a pair of prefixes, but it is not a general-purpose box for entering a long list of alternatives.
“Multiple criteria” can mean different things. You may want rows that begin with “Ap” or “Ba,” or rows that begin with “Ap” and also meet a condition in another column, such as having a status of “Available.” The first is an OR condition within one field; the second combines conditions across fields. Choosing the right method depends on which meaning you intend.
Use Custom Filter for two prefixes
For two beginnings, Custom Filter is usually the fastest approach. First make sure the data has a header row and that there are no completely blank rows splitting the list. Click a cell in the data, then select Data > Filter. Use the arrow in the column you want to check and choose Text Filters > Custom Filter. In the dialog, choose begins with for the first condition and enter the first prefix.
For example, to keep product names starting with “Ap” or “Ba,” set the second condition to begins with, enter “Ba,” and select Or between the conditions. Click OK. Excel displays rows meeting either condition and hides the others; it does not delete them. The OR setting matters: choosing AND would ask for a single cell to begin with both “Ap” and “Ba” at once, which ordinary text cannot do.
- Use Or when either prefix is acceptable.
- Use And when both conditions must be true for the same cell, such as beginning with “A” and also meeting another compatible text condition.
- Enter only the starting text in a Begins With condition; do not add an asterisk unless you have a specific reason to use wildcard criteria in another filter method.
To remove the restriction, open that column’s filter menu and choose Clear Filter From followed by the column name, or use Data > Clear to clear the filters on the range. Clearing a filter reveals hidden rows; it does not change the underlying cell values.
Use Advanced Filter for three or more prefixes
Excel’s Advanced Filter can apply a longer list of alternatives without adding a helper column. Set up a small criteria range in an unused area of the worksheet. Copy the target column’s header exactly into the first cell of that range. Under the header, enter each prefix followed by an asterisk. For example, if the source header is “Product,” enter “Product” as the criteria header and put “Ap*,” “Ba*,” and “Ch*” in separate cells below it.
Click inside the source list, then choose Data > Advanced in the Sort & Filter group. Confirm that the List range covers the full data, including its header, and set the Criteria range to the header and alternatives you prepared. Choose Filter the list, in-place to hide nonmatching rows, or choose Copy to another location and specify a destination if you need a separate result. Click OK.
In an Advanced Filter criteria range, criteria on separate rows are alternatives: they work like OR. Criteria on the same row in different columns are combined like AND. Thus three prefixes under one header mean “starts with Ap OR Ba OR Ch.” If you also require a status of “Available,” place that status criterion on the same row as the relevant prefix; create additional rows for other prefix-and-status combinations if needed.
The asterisk is a wildcard meaning any sequence of characters, including no characters. “Ap*” therefore matches “Apple” and “Apricot.” Wildcards are part of the criteria syntax here; the Custom Filter dialog’s Begins With choice already supplies the starts-with behavior, so typing an asterisk there is generally unnecessary. Keep the criteria range outside the list, and make sure its header matches the source header exactly, or the filter may not interpret the criteria as intended.
Use a helper column for a reusable prefix list
A helper column is useful when the prefix list changes often, when you want to see which rows qualify, or when the list has many entries. Suppose product names are in A2:A100 and the prefixes are listed in H2:H4: “Ap,” “Ba,” and “Ch.” In D1, add a heading such as “Prefix match.” With the data and prefix layout just described, enter this formula in D2, then fill it down through D100:
=SUMPRODUCT(--(LEFT(A2,LEN($H$2:$H$4))=$H$2:$H$4))>0
The formula checks whether the start of A2 matches any listed prefix and returns TRUE if at least one matches, otherwise FALSE. Filter the helper column to TRUE to display qualifying rows. For example, “Apple,” “Banana,” “Cherry,” and “Chocolate” qualify for those three prefixes; “Pear” does not. Avoid blank cells in the prefix list, because a blank prefix can make the test match every row.
In Microsoft 365, you can also return matching rows to a separate area with a dynamic-array formula. With the same data in A2:C100 and the TRUE/FALSE helper results in D2:D100, enter this in an empty cell outside the source data:
=FILTER(A2:C100,D2:D100,"No matches")
FILTER spills the matching records into nearby cells and shows “No matches” if there are none. Leave the spill area clear so Excel can display the results. FILTER is available in Microsoft 365 and Excel 2021 or later; it is not available in older perpetual versions such as Excel 2019. The helper-column method also works with ordinary filtering if you are using a version without FILTER.
Choose the method that fits the job
- Two prefixes, one-time task: Custom Filter is quick and easy to inspect.
- Three or more prefixes: Advanced Filter is a good choice when you want to filter the original list using a visible criteria range.
- A frequently updated list or visible match flag: A helper column makes the logic explicit and simple to change.
- A separate, automatically updated result: Use the helper column with FILTER in Microsoft 365 or Excel 2021 and later.
Excel’s regular column filter can also combine different columns. For example, apply a begins-with condition to Product and select “Available” in Status. Those separate column filters work together as AND: a row must pass both active filters to remain visible. Within a single column’s checkbox list, selecting several distinct values is also an OR-style choice, but that selects complete cell values; it does not mean “begins with any of these prefixes.”
Common problems and how to fix them
If expected rows are missing, first check that you applied the filter to the intended column and that the prefix is at the very beginning of the cell. A leading space is a character, so a value like “ Apple” does not begin with “Ap.” Use Find or inspect the cell to identify unwanted spaces. Also check for mixed data: a column containing numbers, dates, and text may not respond to a text condition in the way you expect.
If Advanced Filter returns no rows, verify that the criteria header exactly matches the list header, including spaces. Confirm that the asterisk is present after each prefix and that the criteria cells are on separate rows for OR logic. For Custom Filter, make sure the conditions are joined with Or rather than And when either prefix should qualify.
Filters hide rows rather than removing them. A copied or exported view may therefore differ from the full list, while the original records remain in the worksheet. Before sharing results, clear filters or clearly label a copied result as filtered. If the source is an Excel Table, its header filters normally expand with new table rows; for a plain range, confirm that newly added rows are included in the filtered range.
Frequently Asked Questions
Can Excel’s Begins With filter accept more than two criteria?
Not in the standard Custom AutoFilter dialog, which provides two condition lines. Use Advanced Filter for several prefixes, or a helper column when you want a maintainable, expandable list.
Should I use AND or OR for multiple prefixes?
Use OR when a row should match any one of the prefixes—for example, “Ap” or “Ba.” AND requires both conditions to be true for the same cell, so it is usually not right for alternative beginnings.
Does Begins With match uppercase and lowercase differently?
Ordinary Excel AutoFilter text matching is not case-sensitive, so “ap” generally matches “Apple.” If case-sensitive matching is essential, use a formula-based approach designed for that requirement rather than assuming the menu filter distinguishes letter case.
Can I filter for text that starts with one of several letters?
Yes. Treat each letter as a prefix: use two Begins With conditions with OR, or list letter-plus-asterisk criteria on separate rows in an Advanced Filter criteria range.
Does filtering delete the rows that do not match?
No. A filter hides nonmatching rows from view. Clear the filter to show them again; use a separate copied result if you need a distinct subset of records.
Is the method different on Mac or Excel for the web?
The core column-filter options are similar, but ribbon placement and dialog presentation can vary by platform and update. The steps above describe Microsoft 365 for Windows; if Advanced Filter is not available in your interface, use the helper-column method and filter its TRUE results.
Related
- Excel Custom Number Format for Day of Week: ddd and dddd
- Excel Custom Number Format for Negative Numbers in Brackets
- Excel Custom Number Format Cheat Sheet and Examples
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Filter Drop-Down Shortcut: Open a Column MenuIn Excel for Microsoft 365 on Windows, select a cell in a filtered column and press Alt+Down Arrow…
- Excel SUM Ignore Errors: Formulas for Clean TotalsYes. To sum numbers while treating error cells as zero in Microsoft Excel for Microsoft 365, use =SUM(IFERROR(B2:B6,0));…
- EDATE in Excel: How to Add Years to a Date CorrectlyExcel’s EDATE function adds months, not years. To add a whole number of years to a date in…
- Excel Formula for the Greater of Two Values: MAX or IF?To return the greater of two numeric values in Excel, use =MAX(A2,B2), assuming the values are in cells…
- SUMIF Excel: Sum Cells Containing Specific TextTo sum values when a related cell contains particular text, use SUMIF with asterisks as wildcards. With descriptions…
- SUMIF Between Two Values in Excel: Formula & ExamplesTo sum values between two limits in Excel, use SUMIFS, which applies both a lower and an upper…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.