View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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!