All variations of a set of numbers and letters

G

Guest

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add up letters to equal a number value. 1
Formulas to display all 3 letter combinations in 8 letters 1
Count of unique values 8
changing column letters to numbers , etc. 3
Validation ?:Accepting both Numbers AND specific letters("N","n"," 2
Display all combination of letters 7
Column headers numbers instead of letters 2
Why are column headings numbers instead of letters? 1

Top