Generating a list of all possible number/letter combinations

[orion]

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?

 

[Jim Cone]

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
(e-mail address removed)

 

[Tom Ogilvy]

Sub tester1()
Dim i As Long, j As Long
Dim k As Long, ii As Long
Dim varr(1 To 36) As String
For i = 1 To 10
varr(i) = i - 1
Next
j = 11
For i = 65 To 90
varr(i - 54) = Chr(i)
Next i
ii = 0
For i = 1 To 36
For j = 1 To 36
For k = 1 To 36
ii = ii + 1
Cells(ii, 1).Value = "'" & varr(i) & _
varr(j) & varr(k)
Next
Next
Next
End Sub

 

[orion]

Thank you so much Jim and Tom, you're brilliant!