alphanumeric string

  1. J

    How to sort alphanumeric text after dash starting with number then letter

    <tbody> -- Excel or Access version: Excel 2013 Computer operating system: Windows 7 Sample data: Sheet1 <colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:79px;"><col style="width:30px;"><col...
  2. S

    Sum numbers from a text string AND in a range

    I'm working on data from b3:ac76. Most cells have a value of zero, some cells have alphanumeric values (e.g. A6, A2, B1, J2). I want to be able to sum all numbers where the first letter is "A", then all values where the first letter is "B", and so on. Based on my example above, the value of A's...
  3. L

    Extracting alphanumeric pattern "???###" from variable position in string

    Hello all, I'm running Windows 7, and Excel 2010. I have a question very similar to the one in the thread entitled "Extracting data based on an alphanumeric pattern" which is here: http://www.mrexcel.com/forum/excel-questions/712101-extracting-data-based-alphanumeric-pattern.html My cells in...
  4. W

    Another extraction of Alphanumeric text

    Now instead of pulling out the number from the middle, I need the end... This one has really held me up since the final string can have all sorts of symbols: ., -, @, etc. For example: AB-1234569- 123.123.123.123 CD-012345 -asdblkdf0934 EF-987654321-abc-123-def-987 GH-32165497-asdkfj.ekrjw...
  5. W

    Extracting a number string from an alphanumeric string of text.

    I've been trying to pull out a middle portion of numbers from a string of text. The tricky part is the limiters on either side of the string can be found in other places at times. For example: AB-1234569-123.123.123.123 CD-012345-asdblkdf0934 EF-987654321-abc-123-def-987...
  6. M

    Need help on a code extracting data

    Hi all, this is my first post here and i hope you guys can give me a little help here :))) I need to search for and extract an alphanumerical string that is either in the form of AXXXX, A XXXX, BXXXX or B XXXX, with XXXX being any 4 digit numbers. The problem is that the string that I need...
  7. D

    Check length of digits only in alphanumeric string

    If I have the following in A1: "DRG" and have the following in A2: <TABLE style="WIDTH: 1109pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1478><COLGROUP><COL style="WIDTH: 1109pt; mso-width-source: userset; mso-width-alt: 54052" width=1478><TBODY><TR style="HEIGHT...
  8. R

    VBA Vlookup lookup value within alphanumeric string

    Folks: Column K contains my lookup values. Sometimes its just the cost center (CC), sometimes the cost center is to the middle, right or left of different words, hyphens, "/", etc. Many variations. Even the Cost Center numbers are not uniform. But my table array has only 17 different cost...
  9. D

    Extract Number from Alphanumeric String

    Looking for assistance in figuring out the best formula to extract the VOC content value from variable length alphanumeric string. The VOC content is the number just before the "g/L". I need to extract just the number portion just before the units “g/L”. Most of the time there is a space...

Some videos you may like

This Week's Hot Topics

Top