### 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
- The angle between two vectors, Python version
- Drawing in Excel 7 - Creating drawings from coordinates
- Frame Analysis with Excel - 4, 2D frame analysis
- Commenting a block of code in VBA
- Downloads
- Buckling of columns with varying cross section

### Recent Comments

dougaj4 on Buckling of columns with varyi… Marco Valsecchi on Buckling of columns with varyi… Displaying trend lin… on Using LINEST for non-linear cu… RCInteract and RC De… on RC Design Functions 7.03 Larry Schuster on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu…

# Tag Archives: Extract number from string

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

## Extracting numbers from text strings

There is often a need to extract numbers from the start or end of text strings. It’s not too hard to do with on-sheet formulas, but after having done it a few thousand times I decided it would be worth … Continue reading