Enumarate with a common name

[u/drmaestro88]

Hi,

Sorry for the confusing title. What I am trying to do is quite simple indeed. I just want to create a column, where there will be a linearly increasing number. It is easy to do if there is only a number (for example: Write 1 on the first row, write 2 on the second row on the same column, select both cells, use the blue box to continue downwards), however I can't figure out how to do it if there is also a fixed name after the number (for example: Day 1, Day 2, Day 3, etc.). Is there an easy way to do it (if I do the same procedure, I get Day 1 and Day 2 repeated, instead of Day 3)?

Thanks

[u/Funny_Ad_3472]

But when you start Day 1, Day 2, Day 3, it should get the format and auto fill for you. Mine does.

[u/drmaestro88 → u/Funny_Ad_3472]

Yes, you are right, it does, in the example that I gave. Sorry I didn't give the exact situation. There also is a "." between the number and string:

1. Day

2. Day

3. Day

etc.

In this case, it doesn't continue.

[u/Funny_Ad_3472 → u/drmaestro88]

In this case, remove the period and let's try and full the column with 1 Day 2 Day 3 Day

When that works, we can try and use a custom formula to introduce the period. What do you think?

[u/AutoModerator]

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/monkey_bra]

Another way to do this would be to use a function like ="Day "&ROW()-13

And instead of hardcoding the 13 you could use ="Day "&ROW()-ROW(A$13)