Excel Filter Between Text Ranges: Steps and Limits

Formulas & functions · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, open the column’s filter menu, choose Text Filters > Custom Filter, and set two conditions: “is greater than or equal to” your starting text and “is less than or equal to” your ending text, joined with And. This keeps values that fall between the two entries in Excel’s text sort order; it does not necessarily mean “any text beginning with a letter between these letters.”

Set up a text range filter

Start with a column that has a header and one text value per row. Click a cell in the data, then choose Data > Filter to show dropdown arrows on the headers. Open the arrow for the text column, choose Text Filters > Custom Filter, and enter the two comparison conditions in the dialog. Set the first to “is greater than or equal to” and the second to “is less than or equal to.” Select And, not Or, so a value has to meet both bounds.

For example, suppose a list contains Cedar, Delta, Elm, Hawk, Iris, and Maple. A lower bound of Cedar and an upper bound of Iris includes values at or after Cedar and at or before Iris in the column’s ordering. It excludes Maple. The actual results depend on the full text values, not just their first letters. If the boundary value itself should be excluded, choose “is greater than” or “is less than” instead of the inclusive operators.

  • Use Data > Filter if the filter arrows are not already visible.
  • Open the dropdown on the column you want to filter, rather than a different column in the same table.
  • Choose Text Filters > Custom Filter and set both conditions.
  • Use And for a continuous range. Use Or only when you want either condition to qualify.

The same general filter workflow is available in Excel for Mac and Excel for the web, though dialog placement and wording can vary slightly. On Windows, Ctrl+Shift+L toggles AutoFilter for the selected range or table; on Mac, the commonly used equivalent is Command+Shift+F.

What “between” means for text

A text range uses ordering comparisons, much like a dictionary sort. Excel compares each value with the boundary text and determines whether it falls before, after, or between those bounds. The comparison applies to the entire string. If the lower bound is Cedar and the upper bound is Iris, a value such as Delta falls inside the range, while Maple falls after it.

Inclusive bounds include text equal to either boundary. In practice, exact equality matters: the value “Iris” is at the upper bound, but “Iris Grove” is not equal to “Iris.” Because the longer value continues after the shared prefix, it sorts after the shorter value. So an upper bound of Iris can exclude Iris Grove even though the words begin the same way. If the desired rule is about first letters or prefixes, use a different approach rather than assuming a full-string range will do that.

Also distinguish text from numbers stored as text. A column containing text labels is compared as text, so a range from “2” to “10” may not behave like the numeric range 2 to 10. Text sorting considers characters, not numeric magnitude. If the entries are quantities, convert them to real numbers and use number filters; if they are identifiers such as product codes, treating them as text may be intentional.

How Excel orders text

Excel’s result follows its text comparison and sorting rules, which can be affected by language and regional settings. In ordinary alphabetic data, readers often expect A through Z ordering, but accents, punctuation, spaces, and digits can affect where a value appears. A leading space, for instance, can make a label sort differently from the same label without that space. If a result looks unexpected, sort the column A to Z and inspect where the boundary values sit.

Text comparisons in Excel formulas are generally not case-sensitive: “cedar” and “Cedar” are treated as equivalent for ordinary comparison tests. Do not assume that capitalization will create separate range boundaries. When case-sensitive matching is essential, a normal AutoFilter text range is not the right tool; use a deliberately designed helper calculation or clean and standardize the data first.

Excel does not interpret a text range as a linguistic category. A range from “C” to “H” is not automatically a request for every word that begins with C, D, E, F, G, or H. It compares whole values with the two literal boundary strings. This is the most important limitation to understand before relying on the filter for names, locations, or codes.

Filter by starting letter instead

If the goal is to include every entry whose first character falls from C through H, use a helper column. This makes the intended rule explicit and avoids the mismatch between full-string comparisons and first-letter comparisons. Add a header such as First-letter range, then enter a formula in the first data row and fill it down.

Assume the text values are in A2:A20 and the one-letter lower and upper bounds are in E2 and F2. For example, enter C in E2 and H in F2. In the helper column’s row 2, use =AND(LEFT(A2,1)>=$E$2,LEFT(A2,1)<=$F$2). The formula returns TRUE for a value such as Delta or Hawk, and FALSE for Birch or Iris. Filter the helper column to TRUE. Empty cells return FALSE under this example because LEFT on an empty cell produces an empty string, which is below the C lower bound.

This formula assumes the first character is the relevant character and that the bounds each contain one character. It does not trim spaces or ignore punctuation. If imported values may start with spaces, clean them or adapt the formula to remove leading spaces. For a specific set of starting letters that are not continuous, such as A, C, or F only, use a helper rule designed for those exact choices rather than a single lower-and-upper range.

Use a table or Advanced Filter

For a list that will grow, convert the data to an Excel table with Insert > Table or Home > Format as Table. Tables provide filter arrows in their header row and generally extend to include newly added rows. The text-filter conditions work the same way; a table does not change what “between” means. It mainly makes the data easier to manage as it expands.

Advanced Filter is another option when you need reusable criteria or more complicated combinations. It uses a separate criteria range with a heading that matches the source column’s heading. Criteria placed on the same row are combined with AND; criteria on different rows represent alternatives. It is useful for repeatable filtering, but it is less direct than the column dropdown for a quick range. For a simple between-text request, the Custom Filter dialog is usually easier.

A filter hides rows that do not match; it does not delete them. To see all rows again, clear the filter from that column or use Data > Clear. If several columns are filtered, clearing one column’s filter does not necessarily remove conditions from the others.

Common problems and fixes

  • Unexpected values are included or excluded: Sort the source column and check the exact position of the boundary text. Remember that Excel compares complete strings, including characters after a shared prefix.
  • The range behaves oddly around numbers: Check whether the cells contain numeric values or numbers stored as text. Apply number filters to actual numbers and text filters to labels or identifiers.
  • Some labels appear duplicated: Look for extra spaces, nonprinting characters, or inconsistent punctuation. Two values that look alike on screen may not be identical.
  • The filter arrow is missing: Select the data and choose Data > Filter. Check that the range has a single header row and that the header is not merged with neighboring cells.
  • Rows you expected to see are hidden: Check other column filters and any manually hidden rows. A row must satisfy all active column filters to remain visible.

For messy imported text, it can be safer to create a cleaned helper column than to rely on visual inspection. Standardizing capitalization, removing unwanted spaces, and separating codes from descriptions helps make filtering predictable. Keep the original values if they are needed for traceability, and apply the filter to the cleaned field.

Choose the right method

Use the Custom Filter when you need a range between two complete text values in the column’s sort order. Use a helper column when you mean a range of first letters, when you need a special inclusion rule, or when your source values need cleanup. Use number filters when the data represents numeric quantities rather than text labels. These methods solve related but different problems, so choosing based on the intended meaning of “between” prevents misleading results.

For a one-time filter, the dropdown is fastest. For repeated reports, put the bounds in clearly labeled cells or maintain a helper column so another person can understand the rule. If the workbook will be shared, include a brief note explaining whether the range uses whole text values or only the first character. That small distinction can matter when someone updates the bounds later.

Frequently Asked Questions

Can Excel filter text between two values?
Yes. Use Text Filters > Custom Filter and set a lower and upper comparison joined by And. The result follows text sort order and compares complete cell contents.

Should I choose And or Or in the Custom Filter dialog?
Choose And for a normal between range: a value must be at or above the lower bound and at or below the upper bound. Or accepts values meeting either condition, which usually produces a much broader result.

Does a filter from C to H include every word starting with those letters?
No. A text range compares whole strings with the literal bounds C and H. To include words by initial letter, test the first character in a helper column and filter the resulting TRUE values.

Can I filter text between two cells instead of typing the bounds?
The Custom Filter dialog is designed for entering criteria in its fields, not linking those fields directly to worksheet cells. For bounds stored in cells and reused in a rule, use a helper formula that refers to those cells.

Does filtering delete the rows outside the range?
No. AutoFilter hides nonmatching rows from view; it does not remove their contents. Clear the filter to show them again, and save a copy before making separate edits or deletions.

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.