Recent Comments
Afazio on Plotting Mandelbrot 
dougaj4 on Plotting Mandelbrot Afazio on Plotting Mandelbrot r/excel - LINEST… on Weighted Least Squares Regress… dougaj4 on Downloads 
Rajesh M on Downloads dougaj4 on Downloads Rajesh M on Downloads dougaj4 on 3DFrame Ver 1.03 and Frame4 Ve… 
Tonny on 3DFrame Ver 1.03 and Frame4 Ve… 
Tonny on 3DFrame Ver 1.03 and Frame4 Ve… 64 bit Excel and the… on Strand7 API GetNode funct… 
wang on Daily Download 5: Frame A… dougaj4 on Daily Download 5: Frame A… 
wang on Daily Download 5: Frame A…
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
