Tag Archives: text to columns

VBA routines for splitting and joining text

Posted on 25/09/2016 by dougaj4

As mentioned in the previous post, I have written two short VBA routines to aid the process of splitting a column of text strings into separate columns, using either a space or any other chosen character as the delimiter.  These … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , , | Leave a comment

The error made in 20% of papers on genes …

Posted on 23/09/2016 by dougaj4

… 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