|Posted by:||Sam Bench (samben…@comcast.net)|
|Date:||Sun, 16 May 2004|
I would like to type six letters across the top of a spreadsheet - one in
Then I would like Excel to concatenate the letters into all the permutations
of the letters (i.e. 6 taken 6 at a time, 6 taken 5 at a time, 6 taken 4 at
a time, and 6 taken 3 at a time). This results in about 2000 possible
permutations of the letters. Each concatenation would be in a single cell.
Does anyone have any ideas on how to automate this process??? Thanks in