How to filter numbers in excel that contain text

This example teaches you how to apply a number filter and a text filter to only display records that meet certain criteria.

1.

Click any single cell inside a data set.

2.

How to filter in excel

How to filter in excel

Types of filter in excel

How to filter a column in excel

Excel filter function

How to extract only numbers from a cell in excel

On the Data tab, in the Sort & Filter group, click Filter.

Arrows in the column headers appear.

Number Filter

To apply a number filter, execute the following steps.

1. Click the arrow next to Sales.

2.

Click Number Filters (this option is available because the Sales column contains numeric data) and select Greater Than from the list.

3. Enter 10,000 and click OK.

Result: Excel only displays the records where Sales is greater than $10,000.

Note: you can also display records equal to a value, less than a value, between two values, the top x records, records that are above average, etc.

Filter only numbers in excel formula

The sky is the limit!

Text Filter

To apply a text filter, execute the following steps.

1. First, to remove the previously applied filter, on the Data tab, in the Sort & Filter group, click Clear.

2.

Next, click the arrow next to Last Name.

3. Click Text Filters (this

how to filter only decimal numbers in excel

how to filter only negative numbers in excel