| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
All variations of a set of numbers and letters
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All variations of a set of numbers and letters
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" 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All variations of a set of numbers and letters
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" 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All variations of a set of numbers and letters
Tim,
You are welcome. Jim Cone "Tim Mc" 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" 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
| displaying letters as average instead of numbers | Excel Discussion (Misc queries) | |||
| Letters = Numbers | Charts and Charting in Excel | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| VLOOKUP for a cell with both letters and numbers | Excel Discussion (Misc queries) | |||
Linear Mode
