1. B

    How can I generate a list of codes in Excel based on criteria?

    I'm trying to make a list of codes based on a format of 001 A 001. They should be 001 to 062, A to E, 001 to 012. I need all combinations, so they would be: 001 A 001 001 A 002 to 001 A 012, then up to 001 E 012 Then 001 B 001 to 012, and so on until 001 E 001 to 012 Then 002, A to E, 001 to...
  2. T

    Alpha numeric excel data validation

    Hi, I'm trying to restrict the entry of data into a cell so it follows this format 1234AA12345 however after trying many formulas I can't get it to work any help would be greatly appreciated.
  3. D

    Extracting AlphaNumeric left of specified value in a ListBox

    Hello, I've created a user form that has a list box populated with a fairly standardized format - a product ID or model number followed by a dash ( - ) then followed by a description. Based on the users selection of an item in the listbox, the model number or ID will be pasted into a range. An...
  4. F

    Sorting Problem

    Hi, I need to sort the following <table x:str="" style="border-collapse: collapse; width: 96pt;" width="128" border="0" cellpadding="0" cellspacing="0"><col style="width: 96pt;" width="128"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; width...

Some videos you may like

This Week's Hot Topics