How to Produce All permutations of Alphabet 3 Letters Long

[longfisher]

How would I use Excel to produce all permutations of the letters of the alphabet that include just 3 letters?

Here's an example:

aaa
aab
aac
aad
aae

etc.

Thanks,

LongFisher

[shg]

Drag row 37 down about 17,000 more rows.

[mdbct]

A quick macro solution would be:

Sub aaaTozzz()
Dim a As Integer, b As Integer, c As Integer, rRow As Long
rRow = 1

For a = 97 To 122
    For b = 97 To 122
        For c = 97 To 122
            Cells(rRow, 1) = Chr(a) & Chr(b) & Chr(c)
            rRow = rRow + 1
        Next c
    Next b
Next a
End Sub

[brucefite]

Drag row 37 down about 17,000 more rows.

Thanks for your solution! I have a dumb question. How do I view the combinations in your spreadsheet?