Autofiltering for partial matches

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?

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