I need a formula to help output some data without manual entry

[nlucy2266]

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

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	NCA-10-A	NCA10A
3	NCA-10-B	NCA10B
4	NCA-10-C	NCA10C
5	NCA-10-D	NCA10D
6	NCA-11-A	NCA11A
7	NCA-11-B	NCA11B
8	NCA-11-C	NCA11C
9	NCA-11-D	NCA11D
10	NCA-12-A	NCA12A
11	NCA-12-B	NCA12B
12	NCA-12-C	NCA12C
13	NCA-12-D	NCA12D
14	NCA-13-A	NCA13A
15	NCA-13-B	NCA13B
16	NCA-13-C	NCA13C
17	NCA-13-D	NCA13D
18	NCA-14-A	NCA14A
19	NCA-14-B	NCA14B
20	NCA-14-C	NCA14C
21	NCA-14-D	NCA14D
22	NCA-15-A	NCA15A
23	NCA-15-B	NCA15B
24	NCA-15-C	NCA15C
25	NCA-15-D	NCA15D
26	NCA-16-A	NCA16A
27	NCA-16-B	NCA16B
28	NCA-16-C	NCA16C
29	NCA-16-D	NCA16D
30	NCA-17-A	NCA17A
Sheet5

Cell Formulas
Range	Formula
A2:A325	A2	="NCA-"&INT(SEQUENCE(81*4,,10,0.25))&"-"&CHAR(MOD(SEQUENCE(81*4,,0),4)+65)
B2:B325	B2	=SUBSTITUTE(A2#,"-","")
Dynamic array formulas.

 

[nlucy2266]

OMG thank you so much! Appreciate it so much

 

[Fluff]

You're welcome & thanks for the feedback.