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
- Smart Indenter and Excel 2013
- Intersections, interpolations, and rotations
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Converting from global to local coordinates (and vice versa)
- Buckling of columns with varying cross section
- Fitting high order polynomials
Recent Comments
Tag Archives: importing text
Importing Text Files; Unix Format
Text files generated on Unix systems have a different convention to denote the ends of lines to that used on Dos/Windows systems (see Newline for more details). This was causing problems with the Text-in2 spreadsheet, with small files being imported with … Continue reading
Posted in Excel, UDFs, VBA
Tagged convert unix to windows, Data types, Excel, extract numbers, importing text, Number formats, splitting text, UDF, VBA
Leave a comment