| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Top 5 Expense Items with Comments | Excel Discussion (Misc queries) | |||
| Finding multiple items from a list | Excel Worksheet Functions | |||
| Finding maximum qty of items to reach given limit | Excel Worksheet Functions | |||
| Wildcard for finding the first numeric digit in a cell? | Excel Worksheet Functions | |||
| Finding concurrent events from a list with a start and an end time | Excel Discussion (Misc queries) | |||
Linear Mode
