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?

On Thu, 14 Feb 2008 12:25:21 -0800 (PST), (E-Mail Removed) wrote:

>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

On Feb 14, 12:49 pm, Ron Rosenfeld <ronrosenf...@nospam.org> wrote:
> On Thu, 14 Feb 2008 12:25:21 -0800 (PST), hiflyinski...@gmail.com wrote:
> >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

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.

<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.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


<(E-Mail Removed)> wrote in message news:e138e661-218f-4483-83f5-(E-Mail Removed)...
| On Feb 14, 12:49 pm, Ron Rosenfeld <ronrosenf...@nospam.org> wrote:
| > On Thu, 14 Feb 2008 12:25:21 -0800 (PST), hiflyinski...@gmail.com wrote:
| > >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
|
| 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.

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:
> On Feb 14, 12:49 pm, Ron Rosenfeld <ronrosenf...@nospam.org> wrote:
>
>
>
>
>
> > On Thu, 14 Feb 2008 12:25:21 -0800 (PST), hiflyinski...@gmail.com wrote:
> > >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
>
> 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.- Hide quoted text -
>
> - Show quoted text -

On Feb 14, 1:58 pm, Pete_UK <pashu...@auditel.net> wrote:
> 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:
>
> > On Feb 14, 12:49 pm, Ron Rosenfeld <ronrosenf...@nospam.org> wrote:
>
> > > On Thu, 14 Feb 2008 12:25:21 -0800 (PST), hiflyinski...@gmail.com wrote:
> > > >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
>
> > 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.- Hide quoted text -
>
> > - 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