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!

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!

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!