parse alphanumeric

  1. G

    RegEx to extract a number from a text string, based on its position in the string.

    I use a fairly simple vba routine to extract data from a table contained in an Outlook email body. The result is an array which contains 1 entry with 7 columns for each email. Here is a sample of one entry in the array: arrList(1,1) = "Sent: Monday, August 28, 2017 10:07:28 AM (UTC-06:00)...
  2. D

    Parse AlphaNumeric String

    Objective: To create a list of numbers based a cell which are present in an alpha-numeric string Issues: "-" shows up at times without the context of numbers (i.e. MS-DRG) Issues: I am not interested in float numbers (i.e. 37.63-37.66) 'Example data in cells (row 1 = A1, row 2 =A2, row 3 =...
  3. N

    Separate letters and numbers in different variations

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

    VBA needed? Separating Text and Numbers from a string into Columns

    Hi All, I need to write a series of formulas (or VBA preferably) to take a single string (column A) and break it into separate columns (B-F). The columns should split the text each time the characters change from text to numeric and vice versa. An example of my data in column A w/ output in...
  5. E

    Parsing A Code Back into Useable information

    I have a code 0ddmyLxx where after the leading 0 is the day, month, year, location;xx is a machine number. The Location is constant as "S". The year is simple by added the number to 2000, and the months of the year by convention are: 1,2,3,4,5,6,7,9, X, N,D where X is Oct, N is Nov and D is Dec...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top