Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Smart Indenter and Excel 2013
- Buckling of columns with varying cross section
- Converting from global to local coordinates (and vice versa)
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Fitting high order polynomials
Recent Comments
Tag Archives: Declaring integers
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