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
F2and 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)