### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Commenting a block of code in VBA
- Drawing in Excel 7 - Creating drawings from coordinates
- Fitting high order polynomials
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- The angle between two vectors, Python version

### Recent Comments

dougaj4 on RCInteract and RC Design Funct… Stephen on RCInteract and RC Design Funct… dougaj4 on Solving Quadratic, Cubic, Quar… dougaj4 on RCInteract and RC Design Funct… Stephen on RCInteract and RC Design Funct… Paridhi Agarwal on Solving Quadratic, Cubic, Quar… dougaj4 on Raw Impact in Cambodia –… dougaj4 on Composite Beam Spreadsheet… Composite Beam Sprea… on Stress increments in prestress… Composite Beam Sprea… on Composite Beam Spreadsheet… dougaj4 on Composite Beam Spreadsheet… Stephen on Composite Beam Spreadsheet… dougaj4 on Composite Beam Spreadsheet… Stephen on Composite Beam Spreadsheet… dougaj4 on Tables and VBA

# 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
1 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