ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I filter a cell to look for anything w/ text vs numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/193577-how-do-i-filter-cell-look-anything-w-text-vs-numbers.html)

Filtering out numbers vs text

How do I filter a cell to look for anything w/ text vs numbers?
 
I have a spreadsheet with data that has numbers and/or text. How do I filter
out the data with only numbers?

Pete_UK

How do I filter a cell to look for anything w/ text vs numbers?
 
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

On Jul 3, 3:30*pm, Filtering out numbers vs text <Filtering out
numbers vs wrote:
I have a spreadsheet with data that has numbers and/or text. *How do I filter
out the data with only numbers?




All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com