alphanumeric

  1. Y

    Lookup between alphanumeric range?

    Hello, Probably being thick here and the obvious answer is alluding me but I need a formula to return a value based on where something is between a range of alphanumeric characters. At a basic level something like the below: <tbody> Start Location End Location Who A001 A100 MT A101 A200...
  2. A

    VBA - get alphanumeric code using date in column header

    Hi again, i am trying to copy a alphanumeric "name" from column A to my source workbook. These names are the usernames of people responsible for particular shifts. <tbody> #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align...
  3. Q

    Sumifs returns 0 value for alphanumeric sumrange

    Hello All, So my data from where i want to pull the sum range contains alphanumeric values in like "GS08, GS09, GS10" The criteria1 range is the range for unique client reference nos. in cells A2:A2688. Criteria1 is to pull each inidividual client reference no. for eg. 64852345. Criteria...
  4. P

    Formula to get data with specific logic from a string

    I have below data in column A, in this string suffixed with data like "(12345/A76D7YF)". I need numeric and alphanumeric character in two different columns. Please note that customer names before above section may also contain (, ) and /. Uniqueness of column A is that after the last open...
  5. M

    Extract numbers from alphanumeric strings

    Hi all, how can I extract (by VBA) this numbers: 149575 191368 191369 with prefix "DUD" and suffix "/nn" from alphanumeric strings with so DB: DUD 149575/18 DUD 191368/17 Ton 39.00, DUD 191369/18 Ton 9.04 Tia. Maurizio
  6. D

    Vlookup alphanumeric cells in a range

    Hello. I am trying to look up alphanumeric values against an alphanumeric range. I can do this against an all-number range, but can't figure out the alphanumeric equivalent. The challenge is that, because it is alphanumeric, I can't define a clear range for Excel. In my numeric lookup, if the...
  7. P

    Allow only certain alphanumeric data in a range

    Hey guys, I need a small help. In my sheet "PRODUCT" range "A1:A150" I want it to only only certain alphanumeric data. I want it to allow only "AK1, AK2, AK3, AK4, AK5 ....... AK100" and "OR1, OR2, OR3, OR4, OR5 ..... OR100" If a user enters anything other than this, then I dont want excel to...
  8. B

    Extracting alphanumeric data

    Excel Guru and Excel expertise I like to ask that I am having alphanumeric data so I want to extract alphabets in one row and numeric in another group example abf145tf=abftf 145 ghj75kl=ghjkl 75 Please hoping answers from excel gurus
  9. P

    How to sum cell with any non numeric characters

    FOR EXAMPLE <tbody> 1000W. 1000W 1000D. 1000E 4000 </tbody> HOW TO SUM ABOVE CASE TO GET ANSWER 4000 WITHOUT REMOVING TEXT & DOT OR ANY NON ALPHANUMERIC CHARACTER GIVE ME VBA CODE OR SIMPLE FORMULA ...
  10. R

    Restrict textbox input to alphanumeric AND dash and underscore?

    Hello, I currently have a userform with a textbox that limits the user input to accept only alphanumeric. I had found that code in an older thread on this board here. The code works great but now I've decided that the user should also be allowed to include "-" and/or "_" along with...
  11. B

    AlphaNumeric

    I have a program that runs off of the data ID (which is for different employees) within Access that makes a barcode. Is there a way to make the data ID alphanumeric? so I want the data ID to be "BAY001 (Bill Brittain), BAY002 (Erick Vaughn), BAY003 (Johan Collins)" and so forth for each...
  12. machopicho

    Alphanumeric string in a cell

    Hi there, i have this problem to solve. In cells i have variable alphanumeric strig as: A1 vbnxm1234 A2 ehfk567 A3 tugfoejrti1597536 and so on. I must extrac string of numbers with a formula if possible... Who is help me??? :-) Thanks to all!
  13. C

    Extracting multiple values from alphanumeric text based on set criteria

    Hello there, I have a set of data which contains part numbers in text fields. Every part number starts "288" and has 10 digits. Because the part number can appear in several columns (but not explicitly) I have concatenated the relevant columns into one alphanumeric column. What I want to do...
  14. L

    Uppercase letters in alphanumeric entry

    Thanks to anyone who may be able to help. I have two columns in a worksheet that require alphanumeric entries. The columns in which the alphanumeric data are entered are column A and column B. Would it be possible to write a VBA code that would change the lowercase alpha characters to...
  15. A

    How to extract any character / or alphanumeric among out of 20 alphanumeric character in excel sheet.

    Dear All, How to extract any character / or alphanumeric among out of 20 alphanumeric character in excel sheet. For e.g. out of 20 alphanumeric i want to extract character no 10 , 11 , 12. Any Assistance, Rgds, aligahk06
  16. M

    Alphanumeric lookup

    Hi, I need to lookup a values in columns in two spreadsheets - the codes I'm looking for are alphanumeric e.g M2971, if the code is present in a column then I would like it to return the word "yes". I've tried Vlookup and changing the format of the cells to TEXT but this doesn't seem to work -...
  17. A

    Automatically generate alphanumeric user id when userform open in excel

    hii friends, I'm new in excel vba,i just want to make a student database in excel userform, and there is a column student id, which is the alphanumeric serial like "ICE/ANG/1001".every time when i open the userform to enter a new student database the id text box goes to auto fillup or generate...
  18. S

    Sorting Alpha-Numeric Data

    Seems this should be fairly simple, but various things I have tried after Google searches have not worked. I would like to sort the following in Alpha-numeric order, but can't get the number sorting correct. P101 P102 P103 P104 P105 P106 P107 P108 P109 P110 P111 P43 P50 P78 P79
  19. A

    VB Help

    Hi - Im trying to enter an array formula into VB if possible - i know the formula is too big but struggling to get it to work. the formula im using is entered in Cell C180 and looks like this. =SUM(--(FREQUENCY(IF('Raw Data Prev Year'!$B:$B<>"",IF('Raw Data Prev Year'!$D:$D=A171,IF('Raw...
  20. U

    Counting the repeating values and displaying with alphanumeric symbols

    Hello, I am not sure if this can be done with a formula, but if it is, I would appreciate the help. I have a set of data some of which can be repeated several times in the same row. And if the values are repeated, I'd like them to be displayed with alphanumeric symbols. For example, If data...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top