| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| copy numbers from numbers+text cell | Excel Worksheet Functions | |||
| Keep text filter away numbers | Excel Worksheet Functions | |||
| extract numbers from cell containing text & numbers | Excel Worksheet Functions | |||
| My filter is not working for numbers & text | New Users to Excel | |||
Linear Mode
