+ Reply to Thread
Results 1 to 2 of 2

How to create sequential alphanumeric list?

  1. #1
    Registered User
    Join Date
    San Antonio, Tx
    MS-Off Ver

    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?

    Thanks in advance,


  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365

    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.
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sequential Alphanumeric entries
    By Tammistar in forum Excel General
    Replies: 11
    Last Post: 06-19-2014, 11:46 AM
  2. Replies: 1
    Last Post: 09-18-2013, 07:11 PM
  3. Generate sequential number after pressing button and create a tracking list.
    By Sam Kuiper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2012, 03:39 AM
  4. Replies: 0
    Last Post: 11-02-2012, 07:57 PM
  5. Replies: 2
    Last Post: 04-05-2005, 11:06 AM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1