I am looking for a formula that will help generate these items. One with dashes in between the letters and the other format all combined. The 3 letter combo is the start of each sequence, followed by a number (up to 90), followed by A-D in order until it goes onto the next number. Any advice would be appreciated and thank you for the help!
NCA-10-A | NCA10A |
NCA-10-B | NCA10B |
NCA-10-C | NCA10C |
NCA-10-D | NCA10D |
NCA-11-A | NCA11A |
NCA-11-B | NCA11B |
NCA-11-C | NCA11C |
NCA-11-D | NCA11D |