View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian17 Brian17 is offline
external usenet poster
 
Posts: 9
Default Custom Filter for ending numbers

Hi, I have a quesiton about filtering. I have a column that contains entries
such as:
aa1100
bb2200
cc4455
cfd9088
fdaniels
fdr8888
jjones
jsmith
kwilliams

How can I filter the list so I see only the entries that do not contain
numbers? I've tried to figure this out using the "ends with" custom filter
option, but can't get it to look for ending in 4 digits. The data will always
end in 4 digits. Any thoughts on filtering it or using a function?

Thanks!
-Brian