Searching a list using wildcards

  • Thread starter Thread starter phil
  • Start date Start date
P

phil

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
 
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
 
Back
Top