+ Reply to Thread
Results 1 to 2 of 2

Creating alphanumeric sequences

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    Boston, MA
    MS-Off Ver
    2010
    Posts
    1

    Creating alphanumeric sequences

    Hi,

    I create barcode labels for LTO Data tapes and recently have been instructed to create pallet sheets to state the barcode sequence on each pallet. Each pallet consists of 1,000 individual tapes and labels. My sequence does not include "I" or "O". I am trying to create a formula that will tell me what the 1,000th label is. I guess it's called a "Base 34" sequence? It begins with 0, goes to 9, then rolls to A before finishing with Z and beginning the cycle over at 0 (skipping I and O as I mentioned before). I was hoping for a formula that I could enter that would be something like =SUM(A1+1000) but that does not work. My excel knowledge is very limited unfortunately.

    Any help would be much appreciated.

    Thanks!

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Creating alphanumeric sequences

    Speshul created a thread for converting from base10 to any other base that resulted in a UDF that you could probably adapt for your own use.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ 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. Creating Alphanumeric Sequences
    By georgebanaszak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 12:59 PM
  2. Replies: 0
    Last Post: 12-12-2012, 06:39 PM
  3. Query - creating relation with field alphanumeric
    By LUCAS MOREIRA in forum Excel General
    Replies: 1
    Last Post: 11-29-2010, 08:04 PM
  4. Replies: 4
    Last Post: 05-15-2010, 06:57 PM
  5. creating a series from alphanumeric data?
    By rykey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-12-2006, 10:24 AM

Tags for this Thread

Bookmarks

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