View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
sacrame sacrame is offline
external usenet poster
 
Posts: 7
Default How to Filter out data that start with 2 numbers

First enter,
=value(left(cellref,2)) (cellref is where you have 10REN, 32TREO, etc.,) Now
sort the data so that the numbered ones you can have separated

"duketter" wrote:

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!