combinations of letters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hiflyinskiier@gmail.com - 14 Feb 2008 20:25 GMT

For a problem, I need to list all of the possible combinations of
uppercase/lowercase letters.
Each combination should have all 26 letters of the alphabet in either
uppercase or lowercase form. There are over 67million combinations.

Is there a way to get excel to list these combinations?

Reply to this Message

Ron Rosenfeld - 14 Feb 2008 20:49 GMT

>For a problem, I need to list all of the possible combinations of
>uppercase/lowercase letters.
>Each combination should have all 26 letters of the alphabet in either
>uppercase or lowercase form. There are over 67million combinations.
>
>Is there a way to get excel to list these combinations?

Hmmm, it seems to me that if you are including all upper and lower case
letters, you have 52 items with 26 of them in any given combination.

Maybe I've misunderstood you, but according to the Excel COMBIN function, this
results in almost 500 trillion combinations.

Using versions of Excel prior to 2007, this would require all the cells in a
workbook with about 30 million worksheets.

--ron

Reply to this Message

hiflyinskiier@gmail.com - 14 Feb 2008 21:00 GMT

> >For a problem, I need to list all of the possible combinations of
> >uppercase/lowercase letters.
[quoted text clipped - 13 lines]
>
> --ron

i have excel 2007 (what is the maximum on that)
anyway, each combination should only have each letter once, but it
could be either uppercase or lowercase
for example, using 3 letters (ABC), some possible combinations are:
ABC, AbC, ABc, aBC, abc, etc.

Reply to this Message

Niek Otten - 14 Feb 2008 21:28 GMT

<For a problem, I need to>

It is a bit difficult to comprehend that you really *need* that.
It is even more difficult to imagine how you will be using the resulting "list".

Maybe you are trying to solve a theoretical problem but underestimated the dimensions of what you ask now?
If so, try and present the real world problem.
If not, apologies! And please help us understand what this is about.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| > >For a problem, I need to list all of the possible combinations of
| > >uppercase/lowercase letters.
[quoted text clipped - 19 lines]
| for example, using 3 letters (ABC), some possible combinations are:
| ABC, AbC, ABc, aBC, abc, etc.

Reply to this Message

Pete_UK - 14 Feb 2008 21:58 GMT

Do you mean that you always want the letters in the same order (a to
z), but that the string is case sensitive so that aBC....YZ is not the
same as ABC....YZ ?

Pete

On Feb 14, 9:00 pm, hiflyinski...@gmail.com wrote:

> > >For a problem, I need to list all of the possible combinations of
> > >uppercase/lowercase letters.
[quoted text clipped - 21 lines]
>
> - Show quoted text -

Reply to this Message

nickeyre1@gmail.com - 15 Feb 2008 04:03 GMT

> Do you mean that you always want the letters in the same order (a to
> z), but that the string is case sensitive so that aBC....YZ is not the
[quoted text clipped - 29 lines]
>
> > - Show quoted text -

yes, pete, that is correct
anyway, the use for this is that i need to make a punnett square for
genetics that crosses
AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz with
AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz

Reply to this Message