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"
<[email protected]>
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]

Tim,
You are welcome.
Jim Cone



"Tim Mc" <[email protected]>
wrote in message...
Awesome add-in ... thanks Jim.