Wildcard for finding items that start with ?

[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?

 

[RagDyer]

Try:

at*

*AND* make sure you also check
"Find Entire cells Only".

 

[Dave Peterson]

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).

 

[KrispyData]

Perfect! Thank you!

Try:

at*

*AND* make sure you also check
"Find Entire cells Only".

 

[RagDyeR]

You're welcome, and thank you for the feed-back.