Thanks GFC . your answer is correct.You may want to try with a helper column that has left(XXX,3)=100
Thnaku very much for the solution.Dear Ram Mher
Think your data is from A1 to A6
Code
10025678
10123456
10221002
10021345
10045678
You want to filter the codes started by 100. So your result will be
10025678
10021345
10045678
Follow the steps..
1. Set filter the range A1:A6
2. Click on the filter combo (A1)
3. Write 100* in the search box
4. Click Ok button
Done!
Remember: If you write 100 instead of 100* then 10221002 this record will also shown in the output list.
Thanks varunda for taking the interest in solvingthe problem of others.Awesome --its working like magic