### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- The angle between two vectors, Python version
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Numerical integration with on-sheet calculations
- Taming Symbols in Excel

### Recent Comments

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… Dave on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Dave McCutchan on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Dave McCutchan on Numerical Integration; Tanh-Si… XY Chart problems… on Plotting Charts With Gaps… XY Chart problems… on When is an XY chart not an XY… XY Chart problems… on XY Chart problems –… dougaj4 on RC Design Functions 8_03 alan green on RC Design Functions 8_03

# Tag Archives: Extract number from string

## Using Flash Fill

There have been several posts here on using functions or user defined functions (UDFs) to extract text or numbers from a longer string (most recently, here), but for many purposes it is quicker and easier to use the “flash-fill” feature, … Continue reading

Posted in Excel, UDFs, VBA
Tagged Excel, Extract number from string, ExtractNums UDF, flash-fill
1 Comment

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

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