Adding number to a succession of cells?

Perhaps it's just my failing memory but I could have sworn I could once do the following sort of thing easily:

I have a couple of text entries in col A:
Day 1:
Day 2:

I want to end up with say 30 rows, successively numbered:
Day 1:
Day 2:
Day 3:
.
.
Day 29:
Day 30:

Is that indeed possible with Excel 2016 please?

Terry, East Grinstead, UK

Put "Day 1" in A1

Move the cursor to the right hand bottom corner of A1 until a thin black cross appears
Click and drag down column A

You should get a succession of Day numbers, Day 2, Day 3, Day 4 etc appearing

Thanks, but that doesn't work with the added colon!

Terry, East Grinstead, UK

Type 1 in the first cell and 2 in the second,
Select both cells and pull the fill handle down until you get to the 30th cell,
Simultaneously press the Ctrl and 1 keys,
Select 'Custom',
In the 'Type' bar paste "Day" 0":" (Note: there is a space between "Day" and 0 but not between 0 and ":")
Select 'OK'
Let us know if you have any questions.

Thanks JeteMc, that works a treat!

Terry, East Grinstead, UK

Another way.
Nevermind This just starts the beginning of the year days .... Jan, Feb, ....

Formula:

Please Login or Register  to view this content.

Originally Posted by FlameRetired

Another way.
Nevermind This just starts the beginning of the year days .... Jan, Feb, ....

Formula:

Please Login or Register  to view this content.

Small tweak to essentially use the format from JeteMc's solution
=TEXT(ROWS($1:1),"""Day ""0"":""")

Originally Posted by xlnitwit

Small tweak to essentially use the format from JeteMc's solution
=TEXT(ROWS($1:1),"""Day ""0"":""")

Thank you. Syntax of TEXT occasionally stymies me.

Originally Posted by terrypin

Thanks JeteMc, that works a treat!

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

xlnitwit, FlameRetired,

Thanks both, got it!

Terry, East Grinstead, UK

You're welcome. Thanks for the feedback and for marking your thread SOLVED. It helps.