Tag Archives: regular expressions

Extracting numbers from text – update

Posted on March 11, 2017 by dougaj4

I have previously posted a spreadsheet with user defined functions (UDFs) using regular expressions to extract numbers from a text string (see Extracting numbers from text and regular expressions). I have now modified the Extractnums function to optionally return the numbers … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , | 1 Comment

More on Regular Expressions

Posted on December 8, 2014 by dougaj4

The previous post presented a User Defined Function (UDF) using regular expressions to extract all numbers, or a selected number, from any string (or a list of strings).  In this post I will look more closely at the code used to achieve … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 9 Comments

Extracting numbers from text and regular expressions

Posted on November 30, 2014 by dougaj4

Daily Dose of Excel recently had a post on extracting a number from a specified position in a text string, using mega-in-sheet-formulas like: This reminded me of a post from earlier this year, which provided a User Defined Function (UDF) … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 3 Comments

Extracting numbers with regular expressions

Posted on April 12, 2014 by dougaj4

Shortly after I wrote about extracting numbers from text strings, Winston Snyder at dataprose.org wrote a detailed article about using “regular expressions” to separate text from numbers in any string.  I have adapted his routine for the same purpose as … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 19 Comments