### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Fitting high order polynomials
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Cubic Splines
- Using LinEst() on data with gaps
- The Conjugate Beam Method
- Passing variable argument lists from Excel to Python via xlwings

### Recent Comments

dougaj4 on ULS Design Functions and … dougaj4 on ULS Design Functions and … dougaj4 on Using LinEst() on data with… Eduardo Torres on Using LinEst() on data with… DonB on ULS Design Functions and … DonB on ULS Design Functions and … James D on ULS Design Functions and … dougaj4 on ULS Design Functions and … James D on ULS Design Functions and … ULS Design Functions… on ULS Design Functions – u… dougaj4 on Numerical Integration; Tanh-Si… Numerical integratio… on Numerical Integration; Tanh-Si… Numerical integratio… on Numerical Integration; Tanh-Si… Dave on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si…

# 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