# How to create sequential alphanumeric list?

1. ## How to create sequential alphanumeric list?

I have a list of 10,000 + alphanumeric numbers in a column.

10AA, 10AB,10AC...After 10AZ it will switch to 11BA.

I need to create 9 sub numbers for each group and store them separately - they will become their own list in a column.

So I need from the master number a new list that looks like this.

10AA1, 10AA2,10AA3...10AA9, 10AB1, 10AB2, 10AB3...10AB9...Through 10AZ9 and than switch to 11AA1...

So how do I create 10,000+ groups of 9 each sequentially numbered?

Mark

2. ## Re: How to create sequential alphanumeric list?

Since there are 16,000 columns in Excel 2010, you should be able to just use the columns to the right to create the lists. Assuming your strings are listed in column A starting at A1...

1) Put this formula in D1:

=INDEX(\$A:\$A, COLUMN(A\$1)) & ROW(\$A1)

2) Copy that down a total of 9 cells to get the first group.

3) Copy that group of 9 cells to the right through column NTT.

There are currently 1 users browsing this thread. (0 members and 1 guests)