Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Cubic Splines
- Strand7 API GetNode functions
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using the Strand7 API
- Using LinEst() on data with gaps
- Alternative iterative solvers
- Fitting high order polynomials
- Writing Arrays to the worksheet - VBA function
Recent Comments
Tag Archives: ExtractNums UDF
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