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.