View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Generating a list of all possible number/letter combinations

orion,

I have written an Excel add-in "Display Word Combinations". It should do
what you want...

All possible combinations for a series of characters are determined. (alpha
and or numeric)
Duplicate combinations are eliminated and a listing of the result is added
to the first empty column on the worksheet.
Valid words in the list are highlighted and shown at the top of the list.
It handles 3 to 8 character combinations and come with a one page Word.doc
install/use file.

It is available (for free) upon direct request. Remove the xxx from email
address.

Regards,
Jim Cone
San Francisco, CA
XX

"orion " wrote in message
...
I have to generate a list of all possible letter/number combinations of
the form _ _ _. There are no restrictions, it can start with a letter,
or a number, have no numbers (AAA), or no letters (000). Any ideas on
how to do this in excel or using VBA?