alphanumeric

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi. I have single column of text that looks mostly like numbers, and I need it to sort (using VBA) in a more logical looking way. For example I would like it to look something...

Hi there, I am trying to do sort a mixture of numeric, alphabetic and alphanumeric cells. My data is as follows in say column A : 2,1,0,g,f,1a,0a What I want to achieve is to end up with the the following order : f,g,0,0a,1,1a,2 By converting the data to text and then sorting I do manage to...

My town conducts a survey of our residents every year using zoomerang. We want to provide each household with a unique 6-digit alphanumeric character (like B3LM25 or K7ST46) in order to access the survey. I need to provide our printer with a file/list of 5000 different codes so he can print...

I have a list of over 15,000 alphanumeric figures (column A) that I need to parse out as follows (columns B-E) seperating letters from numbers in sequence:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <TABLE style="BORDER-BOTTOM: medium none...

I've been looking and looking, but I can't get any of the Google search formulas to work on my alphanumeric string. I just completed a survey and the first 2 questions were multiple choice from 40 options. Users were asked to pick 10 options for each of the questions. I'm now left with a...

I have an alphanumeric cell. If the cell contains any letter then I want to keep the cell as is. If the cell doesn't contain any letters but starts with a 0 then drop the zero and enter remaining number as is. Otherwise if cell contains no letters and doesn't begin with a zero keep as is...

Need help on how to formulate an if-then condition with an alphanumeric dataset. Data A1= XYC75007942 A2= XYC75007494 A3= BTA75041970 A4= BTA75029975 A5= MAA00176 If the data format is XXX75###### if true, then return "correct", otherwise "incorrect" So, using the example data above, cell A1...

Hi, I see many questions on numbers being formatted to dates, but I have a problem with alpha-numeric items converting to dates. I am importing data from a web page (*.htm,html) for excel 2003. The data I am importing is like JAN14. This changes to 14-Jan (with custom or general format) and if...

Hi all, first post. I have recorded a macro to do an equity and bond stock reconciliation using VLOOKUPs on market sedols, but I am having a problem making this work for alphanumeric sedols, which I think is to do with the cell format. For example, if I was reconciling an account with three...

Okay, I've been trying to think of a way to auto fill this series: Column A <TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT...

Hi All, I have a column that has numbers and alphanumeric values. For instance: 254 18 3133 ABP10 SEP14 897 WN231 I would like to have them sort like this: 18 254 897 3133 ABP10 SEP15 WN231 If I change the cell formats to a number it almost works, however excel is seeing the SEP15 value...