Thread
:
How to Filter out data that start with 2 numbers
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
How to Filter out data that start with 2 numbers
Helper column is one way
=ISNUMBER(VALUE(LEFT(A2,2)))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"duketter" wrote in message
...
I am trying to filter out data so it does NOT show data that starts with 2
numbers. For example, I have data that can be 10REN, 32TREO, GREM, OPEE.
I
want to only see GREM and OPEE (data that doesn't start with numbers). I
don't want to see the data that starts with 2 numbers. Anyway this can be
done?
Thanks!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett