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 , , , , | 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

Posted in Excel, UDFs, VBA | Tagged , , , , , | 4 Comments

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 , , , , , , | 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 , , , , , | 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 , , , , , | 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

Posted in Excel, UDFs | Tagged , , , , | 6 Comments