Tag Archives: extracting numbers from text

More on Regular Expressions

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 , , , , | 10 Comments

Extracting numbers with regular expressions

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