How do I filter a cell to look for anything w/ text vs numbers?

  • Thread starter Filtering out numbers vs text
  • Start date
F

Filtering out numbers vs text

I have a spreadsheet with data that has numbers and/or text. How do I filter
out the data with only numbers?
 
P

Pete_UK

In a helper column you can introduce a formula like:

=ISNUMBER(A2)

assuming your values are in column A. Copy this down and it will give
TRUE or FALSE, and you can filter on this.

Hope this helps.

Pete
 
Top