View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary Mary is offline
external usenet poster
 
Posts: 190
Default Filter first two characters

Hello,
I need to filter a column of data that has 4 characters on the first two
characters only.

1100
1110
1140
1190
1550
1590
1600
1700

I want to filter everything starting with 11xx and 15xx. The list will vary
by month but I will always need those two groups.

Thanks!
Mary