Wildcard for finding items that start with ?

  • Thread starter Thread starter KrispyData
  • Start date Start date
K

KrispyData

I would like to search for data that starts with "AT". When I use "AT*" it
also gives me results like HEAT or HAT when what I really want are results
like ATTIC or ATONE. Is there a way to do this?
 
Another way (maybe...).

If the data is in a single column, you could apply Data|Filter|autofilter and
show only the cells that begin with AT (under the custom option).
 
Back
Top