How to generate all 3 letter combinations

There is more than one set of formulas that will do it. Here is a shot at it. I think it works but I have not created a table of all combinations:

Starting at row 2,
Column B =MOD(ROW()-2,26)+65
Column C =MOD(TRUNC((ROW()-2)/26,0),26)+65
Column D =MOD(TRUNC((ROW()-2)/26^2,0),26)+65
Column E =CHAR(D)&CHAR(C)&CHAR(B)

It does one combination per row, you didn't expect all combinations to appear in cell E2 did you? You'll need 17,576 rows of these formulas to get all combinations.

It is quickest to create a lot of rows if you start with a blank table; no formulas. Once you have all the rows you can type in one row of formulas and then copy/paste to all the other rows in one fell swoop at the end.

Message was edited by: Badunit