Hello All and Thank You in advance!
I need to create a formula that will generate serialized alpha numeric numbers. First column is how I believe my output needs to look. But, I've added column two and three to ask how I can create changes to my data if I need to create larger numbers. I guess what I'm asking is to train me in how to modify my data if I need to create other variations: If my data length needs to change or I need to replace a numeric character with an alpha characters. Once all the right hand numbers cycle thru all the sequential variations, the alpha increase by 1, eventually all the way thru the alpha options to scrolling up the first numeric position. ie (Finally, whatever combination I use, it needs to be fixed length. Example one is always 5 characters, same with example two, example three will always be 6 characters.) (This may not be needed and I'm sure it adds a completely different level of complexity but, what if I never wanted to use the letter "O" so there would never be the confusion between the letter "O" and the number "0"?)
<tbody>
</tbody>
I want the combinations to be created sequentially all the way from the lowest alpha number combinations, finishing with the last style number combination.
I don't know VB so...
Thank You!!!
I need to create a formula that will generate serialized alpha numeric numbers. First column is how I believe my output needs to look. But, I've added column two and three to ask how I can create changes to my data if I need to create larger numbers. I guess what I'm asking is to train me in how to modify my data if I need to create other variations: If my data length needs to change or I need to replace a numeric character with an alpha characters. Once all the right hand numbers cycle thru all the sequential variations, the alpha increase by 1, eventually all the way thru the alpha options to scrolling up the first numeric position. ie (Finally, whatever combination I use, it needs to be fixed length. Example one is always 5 characters, same with example two, example three will always be 6 characters.) (This may not be needed and I'm sure it adds a completely different level of complexity but, what if I never wanted to use the letter "O" so there would never be the confusion between the letter "O" and the number "0"?)
| 1A001 | 1AA01 | 1A0001 |
| 1A002 | 1AA02 | 1A0002 |
| 1A003 | 1AA03 | 1A0004 |
| 1A999 | 1AA99 | 1A9999 |
| 1B001 | 1AB01 | 1B0001 |
| 1B002 | 1AB02 | 1B0002 |
| 1B003 | 1AB03 | 1B0003 |
| 2A001 | 2AA01 | 2A0001 |
| 2A002 | 2AA02 | 2A0002 |
| 9Z999 | 9ZZ99 | 9Z9999 |
<tbody>
</tbody>
I want the combinations to be created sequentially all the way from the lowest alpha number combinations, finishing with the last style number combination.
I don't know VB so...
Thank You!!!
