Recent Comments
Tag Archives: text to columns
VBA routines for splitting and joining text
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 Concat, Concatenation, Excel, JoinText, text to columns, TextJoin, UDF, VBA
Leave a comment
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
Newton Excel Bach, not (just) an Excel Blog 