Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Daily Download 4: Continuous Beam Analysis
- P-Y Curve function
- Frame Analysis with Excel – 7; Shear deflections and support displacements
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