Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Latex Maths Text in Excel
- Filling Blanks with Go To-Special (and local help rant)
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Downloads by category
- Taming Symbols in Excel
- Daily Download 3: ULS design of reinforced concrete sections
- Retrieving unique values from a range or array ...
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