I am looking to generate a bunch of alphanumeric codes and I need some help
The first 2 must be random lowercase letter
the rest can be numbers
2nd 2 numbers range 1-12
3rd 2 range 1-31
4th 2 range 1-99
can someone help with this?
thanks
I am looking to generate a bunch of alphanumeric codes and I need some help
The first 2 must be random lowercase letter
the rest can be numbers
2nd 2 numbers range 1-12
3rd 2 range 1-31
4th 2 range 1-99
can someone help with this?
thanks
Please try:
Formula:Please Login or Register to view this content.
@Hans: beat me to it. I had the exact same formula, so no point posting it
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks