How to create a list of numbers with specific condition

Posted on


I would like to create a list of number like yymmddaabbbb

aa:specific numbers like 01, 21 ect;
bbbb: from 0000 to 9999

Is it possible to create a list of number like I stated above?
I am beginner in Excel, but I really need to know how to do it.


You asked how to create a list yymmddaabbbb but did not give further details.

For below, the number of rows = the length of your list.

  • Start at row 1
  • for each row, enter in the cells the following
  • In column A enter the desired yy
  • In column B enter the desired mm
  • In column C enter the desired dd
  • In column D enter the desired aa
  • In column E enter the desire bbbb
  • In column F enter =CONCATENATE(A1,B1,C1,D1,E1)
  • Copy F1 to F2 and so on


Excel can help you fill cells. Select two or more cells in a column and in lower right is small square, put your mouse over it and it will turn into a plus sign “+”, click on it and drag it down.

IF you already have an adjacent column full of data, you can DOUBLE click the square box and Excel will automatically fill in the cells to the bottom of the list.

If your selected cells, that you started with, all have the same number, that number will be filled in. The number will stay the same number

If the cells have 1, 2, and 3, Excel will fill in your bbbb numbers to 1000 automatically. Excel will increase the number by one for each row

Excel will also update the formula above so that the row number will update so that =CONCATENATE(A1,B1,C1,D1,E1) will become =CONCATENATE(A2,B2,C2,D2,E2) and so on. (A1 = column-row)

Your data will consist of a prefix part and an incrementing part.

Say we want the prefix part to be:


In A1 enter the formula:


Then apply this custom format to A1:


enter image description here

Then copy A1 downward:

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *