View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Jon is offline
external usenet poster
 
Posts: 183
Default how to filter by the first digit of list

Hi,
I have the following 2 columns
ID Text
1000 abc
1001 def
1002 €¦€¦
1003
1004
2000
2001
2002
3000
3001
What I want to do is filtering the list by using for example the first 3 digit
For example, I want to filter by using 1000 and its sequence numbers 1001,
1002€¦..
How to do that