Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Downloads
- The history of the theory of beam bending - Part 1
- Frame Analysis with Excel 1 - Single beam
- Contour plots with Excel and Matplotlib
- Function roots with the Inverse Quadratic Method
- Frame Analysis with Excel - 4, 2D frame analysis
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category
Recent Comments
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