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

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

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!