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
- Converting from global to local coordinates (and vice versa)
- Smart Indenter and Excel 2013
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Buckling of columns with varying cross section
- Fitting high order polynomials
Recent Comments
Tag Archives: Concat
VBA routines for splitting and joining text
As mentioned in the previous post, I have written two short VBA routines to aid the process of splitting a column of text strings into separate columns, using either a space or any other chosen character as the delimiter. These … Continue reading
Posted in Excel, UDFs, VBA
Tagged Concat, Concatenation, Excel, JoinText, text to columns, TextJoin, UDF, VBA
Leave a comment