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