Excel Filter Out Text: Keep Numbers or Hide Words

Formulas & functions · Updated November 19, 2026

To filter text out of a mixed Excel column and keep numeric rows, use a helper column with ISNUMBER, then filter the helper for TRUE. For example, if the values to check are in B2:B100, enter =ISNUMBER(B2) beside the first row, fill it down, and choose TRUE in the helper column’s filter menu. This hides rows whose checked cell is text without deleting them.

What “filter out text” can mean

The phrase can describe a few different tasks, and the best method depends on which one you mean. You might want to keep only numbers in a column, hide records whose description contains a word, or remove text values from the workbook altogether. These are different operations: filtering changes which rows are visible, while deleting or transforming values changes the data itself.

For example, a quantity column might contain 12, 0, -3, the text “pending,” and a blank. Keeping numeric entries should retain 12, 0, and -3; a rule that merely looks for positive values would incorrectly discard zero and the negative number. A text search such as “does not contain pending” is useful for a different question, but it is not a dependable way to identify every numeric value.

How Excel’s regular filter works

Excel’s AutoFilter hides entire rows based on the values in a selected column. It does not remove those rows, and it does not change the underlying cell contents. To enable it in Excel for Microsoft 365 on Windows, click a cell in the data range and select Data > Filter. You can also select the range first. Excel adds a drop-down arrow to each header; open the arrow for the column you want to use.

The drop-down may show a checklist of distinct values and filter commands. When the list is manageable, clear Select All and check just the numeric values you want to retain. This works well for a short, known list, but it can be awkward in a large or frequently changing column. Excel’s Text Filters and Number Filters commands offer criteria such as Contains or Greater Than, but those criteria test particular text or numeric comparisons; they do not provide a universal “keep every cell whose underlying value is numeric” test for all mixed data.

Make sure your data has a single header row and no completely blank row splitting the range. If the data is formatted as an Excel table, filter arrows usually appear in the table’s header automatically. Filtering one column also leaves the other columns aligned with their original records, which is why filtering a full table is safer than sorting or copying just one column.

Use a helper column to keep numeric rows

A helper column is the clearest option when a column mixes numbers and text, or when you need a rule that updates as the data changes. Assume the values being tested are in B2:B100 and the first data row is row 2. In C2, enter =ISNUMBER(B2) and fill the formula down through C100. The formula returns TRUE when the cell contains a number and FALSE for text, a blank, or a number stored as text.

Then turn on the filter if needed, open the drop-down on the helper column, clear Select All, and select TRUE. Excel displays only the rows for which the tested cell is numeric. For instance, if B2:B7 contains 12, the text entry “12,” “pending,” -3, 0, and a blank, the helper results are TRUE, FALSE, FALSE, TRUE, TRUE, and FALSE. Filtering TRUE keeps 12, -3, and 0, including values that a positive-number rule would miss.

Use a header such as Numeric? for the helper column, and keep it if other people need to understand or repeat the filter. You can hide the helper column after applying the filter, but leaving it visible is often more transparent. If you add new rows, check that the formula has been filled into them; an Excel table can automatically extend a calculated column when rows are added within the table.

Return matching rows with FILTER

If you want a separate live result rather than hiding rows in the original list, use Excel’s FILTER function. In Microsoft 365 or Excel 2021 and later, with complete records in A2:C100 and the values to test in B2:B100, enter =FILTER(A2:C100,ISNUMBER(B2:B100)) in an empty area outside the source data. It spills the rows for which column B contains a number, preserving the associated values from columns A and C.

This formula returns a new view; it does not delete or alter the source rows. The result updates when the source values change, provided the formula’s ranges cover those rows. If no row matches, FILTER without an optional empty-result argument returns a #CALC! error. The spill area must also be clear, or Excel may report a spill error. Put the formula outside an Excel table because dynamic-array results cannot spill inside table cells.

For a growing dataset, use a table and refer to its columns in a formula adapted to the table’s actual names, or expand the ranges when new rows are added. A fixed reference ending at row 100 will not include records entered below row 100. FILTER is not available in older perpetual versions such as Excel 2019, so the helper-column method is a practical alternative there.

Hide rows containing particular words

If by “filter out text” you mean hide rows containing a particular word or phrase, use the filter on the text column instead. Open its drop-down, point to Text Filters, then choose a condition such as Contains, Does Not Contain, Begins With, or Equals. Enter the text to test and apply the filter. For example, to hide descriptions containing “pending,” use Text Filters > Does Not Contain and enter pending.

Text criteria are useful for category names, comments, product descriptions, and codes. They do not distinguish numeric values from text in general. Also decide whether capitalization matters for your task: Excel’s ordinary filter text criteria are generally not case-sensitive. If you need case-sensitive matching or a more complex test, a formula-based helper column gives you more control.

To show only rows where a text cell is nonblank, use the checklist and clear the blank entry, if it appears. That is different from excluding all text: nonblank cells could include numbers, dates, or other values, while text values that look like numbers may still be text. Choose a rule based on the data type or content you actually need to test.

Numbers stored as text are a common trap

A cell displaying 12 does not necessarily contain a numeric value. It may contain the text “12,” often because it was imported from another system, preceded by an apostrophe, or entered into a column formatted as Text. Excel’s ISNUMBER returns FALSE for that text entry even though it looks like a number on screen. A green triangle or a warning indicator may signal numbers stored as text, but its presence depends on Excel’s error-checking settings.

If those entries should be real numbers, convert the data rather than silently excluding it. Depending on the data, select the affected cells and use the warning menu’s Convert to Number option, or use Data > Text to Columns and complete the conversion with the appropriate settings. Review the results first, especially if entries contain leading zeros, identifiers, currency symbols, or decimal and thousands separators. Converting a postal code or product code to a number, for example, can remove meaningful leading zeros.

If the entries are identifiers rather than quantities, they may correctly belong as text even when they contain only digits. In that case, filtering them out as nonnumeric may be the right outcome for a calculation but the wrong outcome for a record search. Decide what the values represent before changing their type.

Filter, delete, or clean the source data?

Filtering is reversible and best when you want to inspect a subset while keeping every record. To permanently remove text rows, filter them out first, review which rows are visible, and only then delete the visible rows if that is genuinely intended. Be cautious when selecting filtered rows: verify that the selection covers entire records, not just cells in the tested column. Save a copy before bulk deletion, since it is easy to remove useful records accidentally.

If the goal is a clean, repeatable import process rather than a one-time view, Power Query is another option. In Excel for Microsoft 365 on Windows, select data and use Data > From Table/Range to open the Power Query Editor. Set the relevant column’s data type appropriately, then filter the column to retain the wanted values and select Home > Close & Load. On refresh, Power Query can repeat the transformation on updated source data. Check type-conversion errors and confirm that values stored as text have not been unintentionally lost.

Common problems and checks

  • The filter arrow is missing: Click in the data and select Data > Filter. Check that the range includes the header and that a blank row has not split the data.
  • Some numbers disappear: Check whether they are stored as text. Use ISNUMBER to test the actual cell value, not just how it appears.
  • Blanks remain or vanish unexpectedly: A blank is not a number, so the helper formula returns FALSE. Decide whether blank records should be excluded or handled as a separate category.
  • Only one column seems to move: Apply the filter to the complete table or data range, not to an isolated column. AutoFilter hides full rows when the range is set up correctly.
  • New records are not included: Extend a fixed range, or convert the source to a table so its range can expand with added rows.

On Windows, Ctrl+Shift+L toggles filter arrows for a selected data range. In Excel for Mac, the equivalent shortcut is Command+Shift+F. Ribbon wording can vary slightly between platform layouts, but the Data tab’s Filter command is the standard route. Excel for the web also supports ordinary filtering; advanced workflows and some conversion steps may differ from the desktop app.

Frequently Asked Questions

Can Excel filter out text and keep only numbers?
Yes. Add a helper formula such as =ISNUMBER(B2), fill it down, and filter the helper column for TRUE. This reliably separates numeric cell values from text in a mixed column.

Does ISNUMBER count a number stored as text?
No. A cell containing the text “12” returns FALSE, even if it looks like the number 12. Convert it if it is meant to be a quantity; keep it as text if it is an identifier.

Can I filter out words that contain a specific term?
Yes. Open the text column’s filter menu and choose Text Filters > Does Not Contain, then enter the word or phrase. This excludes matches to that criterion, not every text value.

Does filtering delete the hidden rows?
No. A filter hides rows from view while leaving their values in the workbook. Clear the filter to show them again; delete rows only when you intend to remove the records.

Can I use FILTER to create a separate list?
Yes, in Microsoft 365 and Excel 2021 or later. Use FILTER with an ISNUMBER test to spill matching rows into an empty area. It does not modify the source, and it needs room to display its results.

Why does my numeric filter miss zero or negative values?
A condition such as Greater Than 0 excludes zero and negatives by definition. To keep every numeric value regardless of sign, use ISNUMBER rather than a threshold comparison.

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.