Wildcard for finding items that start with ?
 

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?

Wildcard for finding items that start with ?
 

Try:

at*

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KrispyData" wrote in message
...
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?

Wildcard for finding items that start with ?
 

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 wrote:

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?

--

Dave Peterson

Wildcard for finding items that start with ?
 

Perfect! Thank you!

"RagDyer" wrote:

Try:

at*

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KrispyData" wrote in message
...
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?

Wildcard for finding items that start with ?
 

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

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"KrispyData" wrote in message
...
Perfect! Thank you!

"RagDyer" wrote:

Try:

at*

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KrispyData" wrote in message
...
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?