Automatically create A1 to A??? list

[MSHELP]

Good Morning,

How can I get A1 to ??? automatically fill out as follows;

A1 = Pad 1
A2 = Pad 2
A3 = Pad 3
etc

C3 has total pads. In this case 47 so I would like A1:A47 to automatically fill out Pad 1 to Pad 47 or to whatever value is in C1

Would like to do this without adding any extra rows or columns.

[Fluff13]

What version of Office are you using?

[MSHELP]

using the latest version (2019)

[Norie]

If you have the SEQUENCE function available you could use this.

="Pad "&SEQUENCE(C1)

[Fluff13]

Thanks for that, please update your profile to show 2019, rather than 20.

Try in A1 copied down as far as needed.
=IF(ROW()<=$C$1,"Pad "&ROW(),"")

[MSHELP]

Norie - This worked great. Never used sequence before. Thank You
Fluff - This also works

[Fluff13]

If you have the sequence function, then you are using 365 & not 2019.

[MSHELP]

You are correct! I have 365. We recently did the update. Thank you for the clarification