Formula to create alpha numerical SKU's

I am part of a business that requires alpha numerical SKU's to be created ie: C-0000-AA-9, C-0000-AB-6, C-0000-AC-2 & C-0001-AA-3, C-0002-AA-7

Instead of keying all 9 digits is there a formula that can generate the 4 numerical digits running from 0000-9999 but also able to then add in 1 to 2 alpha digits running alphabetically at the front & end of the sku?

Moderators Note: Please follow Forum Rule #1 and use concise thread titles from now on. Changed for you this time, but please choose a clearer title in the future…Thanks.

In a code like A-0000-AA-0, in what order do the different sections of this SKU changes?
1. A from A-Z
2. 0000 from 0000-9999
3. AA from AA-ZZ
4. 0 from 0-9
Can you please rank them? I assumed the range of all of them. Am I right?

Is the last digit a CHECK digit?

Looking at the SKU's and I can see that it not random. Is it?
It seems to me that last letter have those meaning:
A means Men size S
B means Men size M
C means Men size L
D means Men size XL
E means Men size 2XL, ETC.
H means Ladies size S
I means Ladies size M
J means Ladies size L
K means Ladies size XL
L means Ladies size 2XL

You must have some sort of specific values tables associated with size or color. Don't you?

I'm trying to figure out what part of random numbering you need in this process. I don't think there is any though.
Also, you probably don't want to duplicate an existing SKU. So you must have a list of all SKU used to date.
From this list, a macro could find the next number to use in a specific series like SL.... or C..... assuming you assigned them sequentially.
From there, it would be easy to arrange a special sheet where you could enter all the parts to be numbered with specific characteristics in a table to help create the SKU.
What do you think of that?
It's getting late here in Canada so I'll see your answer tomorrow morning. Good day.

I'm not sure to be able to come up with something usefull. You don't think you want a real sequential numbering system. You want to put some structures in those SKU and this means you need to define some parameters. And that structure, you ought to define it first.
If you want color to be a parameter, you must list most regularly used colors and assign a letter for each of them.
If you want size to be a parameter, you must list most regularly used size and assign a letter for each of them.
You must also define which will be first letter in SKU: Color-Size or Size-Color?
I assume numeric value will be sequencial but I saw that you must use only one number for ONE product. I also assume that men's product will have a different number than the women's one.
Quite a job to program! And as I said earlier, if you don't want to have duplicate SKUs you must have a table of all existing SKUs in usage.

Now, when you have to assign new SKUs, do you have a list of products to work with? Is it in a table form? Can you supply an example?
You mentionned 1000 of SKUs to create. Do you really have that much new products to process?
Do the exercise. Go through all the brain process you do to assign a SKU based only on the description of the object or a batch of similar products.
That's what you want to be programmed.
If you want to go further, please give me as much information as possible.