All variations of a set of numbers and letters

[Tim Mc]

Hi.

Does Excel has a formula that will display all variations of a set of
numbers or letters eg AAB97 would contain AAB97, AAB79, ABA97 etc etc?

Appreciate any help.

Tim

[Jim Cone]

There is the free Excel add-in "Display Word Permutations" at my website
that will do that for up to 8 characters. Download from...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA



"Tim Mc"
<TimMc@discussions.microsoft.com>
wrote in message
Hi.
Does Excel has a formula that will display all variations of a set of
numbers or letters eg AAB97 would contain AAB97, AAB79, ABA97 etc etc?
Appreciate any help.
Tim

[Tim Mc]

Awesome add-in ... thanks Jim.

"Jim Cone" wrote:

> There is the free Excel add-in "Display Word Permutations" at my website
> that will do that for up to 8 characters. Download from...
> http://www.realezsites.com/bus/primitivesoftware
> --
> Jim Cone
> San Francisco, USA
>
>
>
> "Tim Mc"
> <TimMc@discussions.microsoft.com>
> wrote in message
> Hi.
> Does Excel has a formula that will display all variations of a set of
> numbers or letters eg AAB97 would contain AAB97, AAB79, ABA97 etc etc?
> Appreciate any help.
> Tim
>

[Jim Cone]

Tim,
You are welcome.
Jim Cone



"Tim Mc" <TimMc@discussions.microsoft.com>
wrote in message...
Awesome add-in ... thanks Jim.



"Jim Cone" wrote:
> There is the free Excel add-in "Display Word Permutations" at my website
> that will do that for up to 8 characters. Download from...
> http://www.realezsites.com/bus/primitivesoftware
> Jim Cone
> San Francisco, USA
>
>
>
> "Tim Mc"
> <TimMc@discussions.microsoft.com>
> wrote in message
> Hi.
> Does Excel has a formula that will display all variations of a set of
> numbers or letters eg AAB97 would contain AAB97, AAB79, ABA97 etc etc?
> Appreciate any help.
> Tim
>