Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Deflections and Moments in Rectangular Plates
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Dancing Pendulums
Recent Comments
Tag Archives: Extracting text
On long and short formulas and VBA
A recent thread at Eng-Tips asked the following apparently simple question: Starting with a string consisting of numbers with a single central group of letters, how can this string be truncated at the end of the letters, so that for … Continue reading
Posted in Excel, UDFs, VBA
Tagged Creating a VBA module, Declaring integers, Excel, Extracting text, UDF, VBA
Leave a comment