View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Autofiltering for partial matches

Click that filter arrow
choose custom
choose contains
type phonecompany

Or
choose custom
choose equals
type *phonecompany*




PeterJordan wrote:

My bank posts automatic payments for some accounts as follows:

123 PHONECOMPANY XXX
456 PHONECOMPANY XYZ

I know how to autofilter for exact matches -- but it would be very helpful
to autofilter for all the strings that have PHONECOMPANY inside them, whether
or not they begin and/or end with different characters. Is there any way I
can sort or filter for only the rows that have the string PHONECOMPANY, even
if that's an internal string?


--

Dave Peterson