Filter Specific numbers after certain digits

I have thousnads of entries in excel 2010 worksheet like

35540356743

34945356743

34949356743

35563356743

35518356743

 

I want to filter all entries who have values  40 -49 after first three digits. Please check first three entries, their values fall in 40-49 range after first three digits.

 

In short, I want to filter thousands of excel cells who have specific value after first three digits.

 

I appreciate your help.

 

Thanks,

By: Nasir

Leave a Reply

Your email address will not be published. Required fields are marked *