### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Downloads by category
- Drawing in Excel 7 - Creating drawings from coordinates
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Solving non-linear equations with two or more unknowns – 5
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Drawing a Buckyball in Excel

### Recent Comments

dougaj4 on Linking AlgLib C++ to Excel… Using Alglib least-s… on Excel to Alglib via xlwin… Using Alglib least-s… on Evaluating text and calling Py… dougaj4 on Using the Frame Analysis … metrox on Using the Frame Analysis … dougaj4 on Polynomial Update dougaj4 on Polynomial Update #Excel Super Links #… on Working with implied unit… Joshua on Polynomial Update excel1star on Polynomial Update Joshua on Polynomial Update dougaj4 on Polynomial Update Joshua on Polynomial Update dougaj4 on Polynomial Update Joshua on Polynomial Update

# Tag Archives: regular expressions

## Extracting numbers from text – update

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 Excel, Extract number from string, ExtractNums, regular expressions, UDF, VBA
Leave a comment

## 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 Excel, extracting numbers from text, regular expressions, UDF, VBA
9 Comments

## Extracting numbers from text and regular expressions

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 Excel, extract numbers, regular expressions, UDF, VBA
3 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 Excel, extracting numbers from text, regular expressions, UDF, VBA
19 Comments