combination of numbers or letters

[torjan]

Hi
I am new to your wonderful forum, I love all your programs and I was moved by your performance.
I am a student, I have a problem in which I seek a solution lot, I really tried but I could not solve it and I want you to help me to find a solution
So I want EXCEL program that can do all of the possibilities (combinations) possible with the letters a, b, c in character strings composed by 13 elements (elements are a, b and c, that's all, no more)
then the result is 2,197 strings of 13 letters written by these three letters only, for example:
aaaaaaaaaaaaa
abcabcabcabca
aaaaabbbbbccc
aabbccaabbcca
.
.
.
.
.
.
.
etx
and Thank you in advance

[Kaper]

Unfortunately, your estimation is wrong, You will get 1 594 323 different strings, so more than excel can fit in one column.

But you can start and see first few (or more

write in A1 formula:

Please Login or Register  to view this content.

copy it into next 12 columns and then copy all 13 columns some rows down.

to have letters in one string use in N1:

Please Login or Register  to view this content.

(of course write all cells in ...)

and copy down