Filtering Cells

  • Thread starter Thread starter Andy B
  • Start date Start date
A

Andy B

Hi

Use Data / Filter / AutoFilter and then use Custom on the column and select
contains cats
or
contains dogs
 
I want to filter a colomn containing (nnnn)aaaa where n is a numeric and a
is an alpha character. The colomn contains two names eg: cats or dogs
represented by the alpha characters above.

How do I sort the cats from the dogs?

TIA
 
Back
Top