Take the 2-minute tour ×

Is there some sort of mechanism in Excel that lets you create data using a specific pattern? Something like a regex that does all the possibilities.

For example:


Would generate


and so forth.

share|improve this question
@Excellll's answer will work fine, but will change values if the rows are re-sorted, added or otherwise modified. If you want something more flexible and where values become "locked", let us know and we can work on something a little more complex. –  dav Aug 6 '12 at 19:34

1 Answer 1

up vote 2 down vote accepted

As far as I know, there's nothing built in specifically for this purpose. You can, however, get clever and use a formula to generate all the possibilities. In A1, enter the following and fill down (to A64):

share|improve this answer
note that if you need it to start in a different place, the easiest way is to put this formula in a separate spreadsheet, then copy the values instead of the formulas –  Sean Cheshire Aug 6 '12 at 21:15

Your Answer


