Series Pattern database help as soon as possible

[LisaH64]

I've attached a screenshot of the database file I need to make. I figured out how to get the numbers to create the pattern but when I leave in the Letters and dash, it won't create the pattern. Thanks in advance for the help

 

[JamesCanale]

MrExcelPlayground22.xlsx
	A
1	20
2	AT-001
3	AT-001
4	AT-001
5	AT-001
6	AT-002
7	AT-002
8	AT-002
9	AT-002
10	AT-003
11	AT-003
12	AT-003
13	AT-003
14	AT-004
15	AT-004
16	AT-004
17	AT-004
18	AT-005
19	AT-005
20	AT-005
21	AT-005
22	AT-006
23	AT-006
24	AT-006
25	AT-006
26	AT-007
27	AT-007
28	AT-007
29	AT-007
30	AT-008
31	AT-008
32	AT-008
33	AT-008
34	AT-009
35	AT-009
36	AT-009
37	AT-009
38	AT-010
39	AT-010
40	AT-010
41	AT-010
42	AT-011
43	AT-011
44	AT-011
45	AT-011
46	AT-012
47	AT-012
48	AT-012
49	AT-012
50	AT-013
51	AT-013
52	AT-013
Sheet3

Cell Formulas
Range	Formula
A2:A81	A2	="AT-"&TEXT(INT(SEQUENCE(4*A1,1,1,0.25)),"000")
Dynamic array formulas.

 

[LisaH64]

I am not any kind of proficient in Excel, I tried to copy and paste and drag down but that isn't working, can you give me a step by step by chance

 

[JamesCanale]

In A1, put the number that you want your list to go up to. I had 20.
In A2 put this formula:
="AT-"&TEXT(INT(SEQUENCE(4*A1,1,1,0.25)),"000")

No dragging needed.

 

[LisaH64]

thank you so much, I have been trying to find an answer for a while by googling : )