alphanumeric

I have a column of alphanumeric data and want to determine the maximum value in the range but only for values within the range that have a prefix of "EP". I have been able to develop this which gives me the maximum alphanumeric but cannot figure out how to filter for only the EP prefix. The...

Hello, I'm trying to add Data Validation to 50 cells in a column that will only accept: Alphanumeric Hyphens (dashes) No restrictions for length. I did find some examples, but they are all for a single cell. If I try to change it to a range it breaks and won't let me save. I tried this...

I'm wanting to count unique alphanumeric value from column 'user ID', but I'm wanting to include a criteria of date range where column 'Date' is between 12/12/2019 - 18/12/2019. I've tried numerous array formula's but they're all too slow so i'm wanting to know if it's possible to do it without...

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...

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...

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...

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...

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

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...

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...

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

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 ...

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...

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...

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!

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...

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...

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

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 -...

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...