How to Filter out data that start with 2 numbers

  • Thread starter Thread starter duketter
  • Start date Start date
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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbering Rows in Filtered Data - Excel 2002 3
Data Lookup Question 1
COUNTIF Function on filtered data 2
If then Formula 3
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Pivot Table Filter Formula 1
Filtering data based on formula 1
Numbering a filtered list in Excel 2002 3

Back
Top