alpha numeric

Hi, I have a project wherein I need to generate an alphanumeric sequence based on certain values. An example is below: AU1VT11201M (START) AU1VT1120120M (END) AU1CB1120121M (START) AU1CB1120240M (END) AU1 = LOCATION VT OR CB = Product code 1120 = MONTH & YEAR 1-240 = SERIES M =...

I'm trying to create an alpha numeric code for a massive list of direct mail recipients compiled in excel. The code would be [first letter of last name]&"_"&[number 1-10,000 based on alpha order within specific letter (see below)]. Examples below. I can figure out the first letter with left but...

How would I sort this data (using a formula) ascending by number and then letter? <colgroup><col></colgroup><tbody> 17091780-02A 17091555-01A 17091555-01ADUP 17091555-02A 17091559-01A </tbody>

Hi when I was checking my data validation formula I found it failed terribly. The format I'm trying to obtain is: AA##AA####A A is alpha a-z and does not need to be case sensitive # is numeric 0-9 the formula I was using...

Hello! I have a list of manually entered postcodes in excel which I am trying to work with. What I am trying to achieve is a formula that recognises when these postcodes are entered with an incorrect alphanumeric format. So all post codes I am working with should begin with an alphanumeric...

I am looking to create a custom sort list for my data. The data I wish to sort is below: Text C Text D Text 8 Text 1 Text M I would like to sort the data by having the alpha first and the numeric last (the excel default is numeric first, then alpha) - see below: Text C Text D Text M Text 1...

Hey Guys, I am looking to find the Max Alphanumeric Serial Number that is in a column and increment by 1! I have code that finds the last "Sequential" serial number in the column and it increments by 1 but unfortunately all my Serial numbers are NOT Sequential in the column! Can someone please...

My column contains a word which MUST contain AAAAANNNNA (A-Z) i.e. 10 digits 1st 5 Alphabets, next 4 numerical (0-9) & 10th Alphabet (A-Z). If it doesn't next column should give the mistake : i.e. less than 10 digits 3rd value not an alphabet OKAY

Hello, I'm using Excel 2007 on a Windows XP box for creating QA test cases. I looked through the forum and haven't found an answer to my question. I need to be able to auto increment my test case ID in column A by 1 when I hit 'Enter' or click on the next row. I.E. The test case ID value in...

I found some posts related to my problem but the solution just doesn't work for me. I have a list of alphanumeric data that I need to sort. original: 100A 1A 200A 2A 300A 9A Sorted: 1A 2A 9A 100A 200A 300A I tried using the method of using the TEXT formula in adjacent column [=Text...