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
- Buckling of columns with varying cross section
- ULS Design Functions 2.13
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Fitting high order polynomials
- Downloads
Recent Comments
Tag Archives: JoinText
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