![]() |
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? |
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