Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- 3D Frames, axes and stiffness matrices
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category
- Downloads
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Taming Symbols in Excel
Recent Comments
Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin… Roulior Halder on Excel to Alglib via xlwin… dougaj4 on Excel to Alglib via xlwin… dougaj4 on Excel to Alglib via xlwin… dougaj4 on How to digitise a scanned… Gabriel on How to digitise a scanned… Gabriel on How to digitise a scanned… Gabriel on How to digitise a scanned… Roulior Halder on Excel to Alglib via xlwin… Roulior Halder on Excel to Alglib via xlwin… Angelo on Biaxial bending update dougaj4 on Excel to Alglib via xlwin… dougaj4 on Biaxial bending update Roulior Halder on Excel to Alglib via xlwin…
Tag Archives: import text
The error made in 20% of papers on genes …
… and how to avoid it. According to a recent scientific paper “Gene name errors are widespread in the scientific literature” (authors: Mark Ziemann, Yotam Eren1, and Assam El-Osta). The paper says that “approximately one-fifth of papers with supplementary Excel gene lists contain erroneous gene … Continue reading
Posted in Excel
Tagged date formatting, Excel, import text, text format, text to columns
Leave a comment
Dealing with dates 3: opening and saving csv files without data corruption
This post makes use of a spreadsheet for reading data from text files, including comma separated value (csv) files. The latest version includes a routine for saving the imported data in csv format. It can be downloaded (including full open-source … Continue reading
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 tab delimited files and clearing large ranges
Wray Sisk commented on Importing text files with VBA – 3, asking if it could be modified to read tab delimited files. It could be, and has been; download here: Text-in2.ZIP It turned out to be a simple task; just … Continue reading
Posted in Excel, UDFs, VBA
Tagged Excel, Excel 2007 performance, import text, slow clearing, UDF, VBA
2 Comments
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
Importing text files with VBA – 2
Previous post The text file import routines and functions presented in the previous post have been modified with the following additions: Lines of text can be split into separate cells, at any designated character (e.g. a coma or a space) … Continue reading