How can I create sequential number with "." in between numbers?

I'm stumped after many try.
What I'm trying to do on Excel 16 is to create a sequence like this:

abcdefg_##.##.## (## = 00 ~ 99)

ex) abcdegf_00.00.00
abcdegf_00.00.01
.
.
abcdegf_01.00.01
.
.
abcdegf_99.99.99


How can I generate this sequence without manually typing it?


Important:

Also how can I control the number the last 2 digits end?

What I mean by that is, instead of designating the last two digits to end at 99, I want it to end at 39 or 89.


Also, is there an alternative to doing this using other tools and not necessarily excel?
I'm opened to other means of doing it.


I tried to solve this problem but it's beyond my basic understanding of excel.
Thank you!

For the first part of your question, put 0 in cell A1 and put this formula in cell A2...

=1+A1

Then select both cells and use this Custom Format for them...

"abcdegf_"00\.00\.00

Then select cell A2 and copy it down as far as needed.

Let me think about the second question.

EDIT NOTE: Is that "stopping number" to only apply to the last two digits or to each group of two digits? In other words, If the "stopping number" is 39, what comes after this...

abcdegf_00.39.39

Hi ApppleJack and welcome to the forum,

I think you are going to need to build your rows using real numbers and then put a formula in to add those periods. Look at the attached Col a where I typed in cell A1 and then used AutoFill (drag bottom right handle of the cell) to have it auto number downwards. Then in Col B I used a formula of:

Formula:

Please Login or Register  to view this content.

To put those periods in:
Period between counting digits.xlsx

I think Rick showed me the answer with this kind of formula on Sheet 2,

Formula:

Please Login or Register  to view this content.

Period between counting digits 2.xlsx

So, I worked it out. Thanks for the help, again.

A couple of more problems.

1. I actually need to use =A1&TEXT(B1,"\.00\.00.") instead of =A1&TEXT(B1,"00\.00\.00.")

The first two digit segment (bolded) =A1&TEXT(B1,"\.00\.00.")

doesn't cap at 99. It goes all the way to over 14000


2.I cannot copy the column and paste it to clipboard.
I was planning to migrate this date into a text file.

You might need to use my first formula with the Left(), Mid() and Right() in it if the Text(B1 &...) doesn't work.

It would be more helpful if you could attach a sample workbook showing your exact text and need. There might be a much better way to structure your data to get better answers.
Read the yellow text at the top of the page to see how to attach a file.

Yes, silly me. I didn't think about that.
I've been playing with this workbook.
Please have a look the work book.
I clicked on the attachment icon but it doesn't seem to work for me. It just shows a white bar.

I can't seem to post a link to the file on my Googledrive because the site doesn't let me post a link until I make more posts.

Now, I'm trying to figure out a way to set a range to cap the number.
If you look at column "B" in the work book, that's where I should cap the number.

For example, let's just pick a random number
00.00.00.00
...
...
...

39.39.39.39


Thanks!!

Update: Still when I hit the attachment icon, a white bar appears below the icon but nothing else.

The paperclip icon doesn't work, however utilizing the instructions for uploading a Excel spreadsheet/workbook as given in the banner at the top of the page does.
Let us know if you have any questions.

Hey appplejack,

This is the formula you seek:

Formula:

Please Login or Register  to view this content.

See it work in the attached. I did lots of these in a college number theory class.
Mod 39 counting between colons.xlsx

I have some extra columns working my way up to the final answer. You don't need those extra columns but I left them there so you might see what I did.

Hey Rick,

I hate being wrong but you are very right!!
Try this formula instead.

Formula:

Please Login or Register  to view this content.

Mod 40 counting between periods.xlsx
Now starting at zero and having periods instead of colons. I took that number theory twice and did much better the second time around. That was 52 years ago

I think I win this one - UB older than me
Now go wash your hands (again)!