Monthly Archives: October 2017

Quite a long time ago, I wrote a post Fill in the blanks – quickly to talk about the tip to turn a human-reading-freindly table into an Excel-friendly table, as shown below: Have you ever thought about why we are doing … Continue reading →

Rate this:

In the previous post, we talked about the basic of Text to Columns and focused on “Fixed width”. In this post, we will continue to talk about three magical things that Text to Columns could do with ease: Extract part … Continue reading →

Rate this:

There are many not-so-easily-understood terms in Excel. “Text to Columns” should be one of them. Probably due to the name of it, Text to Columns is not a common tool for many Excel users. But indeed, if you know what … Continue reading →

Rate this:

If you have been following my blog for more than three months, you should have read this before. If you wonder why I am reposting it again and again, the answer is simple: it is awesome. You could learn awesome … Continue reading →