Would like help on how to create a sequence in this format

Hello,

Would like help on how to create a sequence in this format:

01-01-A-01
01-01-B-01
01-01-C-01
01-01-D-01
01-01-E-01

I need these to repeat 5 times (rows) where the 3rd value after the dash is A, B, C, D, E. Then Repeat again but this time the 2nd Value update to 02. Need this 18 times where the final set is :

01-18-A-01
01-18-B-01
01-18-C-01
01-18-D-01
01-18-E-01

I then need to do the same sequence but change the value in the first value to 02 (02-01-A-01) etc, etc.

Thank you in advance for any guidance

Samples Locations.xlsxSamples Locations.xlsx

Do you want this in just one column, or in 4 (narrow) columns each containing a separate element?

Pete

One column

Originally Posted by Pete_UK

Do you want this in just one column, or in 4 (narrow) columns each containing a separate element?

Pete

One column

Okay, put this in your starting cell (A1 ?):

=TEXT(INT((ROWS($1:1)-1)/5/18)+1,"00-")&TEXT(MOD(INT((ROWS($1:1)-1)/5),18)+1,"00-")&CHAR(64+MOD(ROWS($1:1)-1,5)+1)&"-01"

then copy down as far as you need to.

Hope this helps.

Pete

Originally Posted by Pete_UK

Okay, put this in your starting cell (A1 ?):

=TEXT(INT((ROWS($1:1)-1)/5/18)+1,"00-")&TEXT(MOD(INT((ROWS($1:1)-1)/5),18)+1,"00-")&CHAR(64+MOD(ROWS($1:1)-1,5)+1)&"-01"

then copy down as far as you need to.

Hope this helps.

Pete

This worked perfectly Pete!! Thank you so much!

You're welcome, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete