Function Problems

How to Filter Excel Names by a Range of Starting Letters

Huda Qurayshi Oct 13, 2026 873 views

Question details

Users need a method to filter a column containing names so it only shows entries that begin with a specific range of letters (e.g., A through H), rather than selecting individual letters manually.

How to Filter Excel Names by a Range of Starting Letters

Product: Excel
Device & OS: not provided
Scenario: Organizing and extracting specific alphabetical groups from a large dataset, such as a contact list or last-name column.
Observed behavior: Users require a custom filtering criterion to evaluate text alphabetically and return all names falling within the specified letter range.

Before you start

Verify that your name column is formatted as Text and does not contain leading spaces, as spaces precede letters in alphabetical sorting and will alter your filter results.

Solution 1Recommended

Use Custom AutoFilter with the Less Than Operator

This is the most efficient way to filter for an alphabetical range starting from 'A'. By using the 'is less than' operator, you can capture all words preceding a specific letter.

In Excel, text is evaluated alphabetically. This means that a name starting with 'H' (like Harris) is considered 'less than' the letter 'I'. Using a less-than operator is a simple workaround to grab continuous letter ranges.

Enable the Filter

Select the header of your names column. Navigate to the Data tab on the ribbon and click the Filter button to add drop-down arrows to your headers.

Access Text Filters

Click the drop-down arrow on the specific column you want to filter. Hover your cursor over 'Text Filters' in the menu, then select 'Custom Filter' from the flyout.

Set the Criterion

In the Custom AutoFilter dialog box, click the first drop-down menu and choose 'is less than'. In the adjacent text box, type the letter immediately following your desired range (e.g., type 'I' to include A through H).

Apply Filter

Click OK. The column will now exclusively display names that begin with the letters A through H.

Use Custom AutoFilter with the Less Than Operator

Test with Sample Data: Always verify the filtered results against a few known data points in your list to ensure no unexpected names were excluded.

Solution 2

Use the 'Between' Logic for Mid-Alphabet Ranges

If you need to filter a range that does not start with 'A' (for example, names starting with C through H), you will need to combine two conditions.

Powerful Data Management

Easily Filter and Sort Text Data in WPS Spreadsheet

WPS Spreadsheet offers intuitive and robust Custom AutoFilter tools that perfectly handle alphabetical text criteria, allowing you to easily manage large lists of names and datasets without complex formulas.

1. Open your dataset: Launch WPS Spreadsheet and open the document containing the list of names you want to filter.
2. Apply AutoFilter: Select your column header, navigate to the 'Data' tab, and click the 'AutoFilter' button.
3. Access Custom Filters: Click the small filter icon on your column header, go to 'Text Filters', and choose 'Custom Filter'.
4. Input the range criterion: Select 'is less than' and enter the letter 'I' to capture A-H, then click OK to instantly filter your data.

Familiar user interface makes it incredibly easy to apply complex custom text filters.Fully compatible with Microsoft Excel formats (.xlsx, .xls) so your filters and data remain intact.Completely free, lightweight, and fast for managing extensive data ranges.

microsoft office alternative - wps office

Frequently Asked Questions

Why does using 'is less than I' capture names starting with H?

In spreadsheet software, text strings are evaluated alphabetically. Any word beginning with 'H', regardless of the letters that follow it (like 'Harris' or 'Hutton'), falls before the letter 'I' in the alphabet. Therefore, the 'less than I' condition accurately brackets everything from A to H.

Can I filter for multiple non-continuous letters at the same time?

Yes. In the Custom Filter dialog box, you can use the 'Or' logic. Set the first condition to 'begins with' and type a letter (e.g., A), choose the 'Or' radio button, then set the second condition to 'begins with' and type another letter (e.g., M). This will show only names starting with A or M.

What should I do if my alphabetical filter is excluding obvious names?

This usually happens when the text data contains leading blank spaces. A space character is evaluated differently than a letter. To fix this, use the TRIM function in a new helper column (e.g., =TRIM(A2)) to clean the text, and then apply your filter to the cleaned column.

Excel & Data Problems