Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching a list using wildcards
I compile crosswords in the Welsh language and have a list of 40,000+ words.
Is there any way I can get Excel to search the list and return all words matching a given pattern using wildcard symbols, B?DD to return BEDD and BYDD, or B*DD to return all words beginning with B and ending in DD Any help would be greatly appreciated. Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching a list using wildcards
Hi Phil
Use Autofilter in the Data menu Use Custum -- Regards Ron de Bruin http://www.rondebruin.nl "phil" wrote in message ... I compile crosswords in the Welsh language and have a list of 40,000+ words. Is there any way I can get Excel to search the list and return all words matching a given pattern using wildcard symbols, B?DD to return BEDD and BYDD, or B*DD to return all words beginning with B and ending in DD Any help would be greatly appreciated. Phil |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching a list using wildcards
Hi Ron,
You are a veritable star and a gentleman to boot. I've spent weeks racking my brains on this one. Thank you so much Regards Phil *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching from one list in another | Excel Discussion (Misc queries) | |||
looking up items in a list with wildcards | Excel Discussion (Misc queries) | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
searching within list | Excel Discussion (Misc queries) | |||
Excel Searching and Wildcards | Excel Programming |