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
- ULS Design Functions 2.13
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: Import large files
Daily Download 32: Text functions
Today’s daily download covers functions to import data from text files into Excel quickly and efficiently, a function to combine text strings, with improved functionality over the built-in Concatenate function, and functions to extract numbers from the beginning or end … Continue reading
Posted in Excel, UDFs, VBA
Tagged combine text strings, Excel, import csv, Import large files, import text, UDF, VBA
1 Comment
Importing text files with VBA – 3
The text import file has been modified to split large files into one or more ranges. The maximum number of rows for each range is specified, together with a sufficient number of valid range names, which may be on the … Continue reading
Posted in Excel, UDFs
Tagged Excel, Import large files, import text, split text, UDF, VBA
20 Comments