How to Filter out data that start with 2 numbers

D

duketter

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!
 
S

sacrame

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
 
Top