Tag Archives: MID

Extract FirstLast names in CamelCase with #Excel formula

Posted on March 10, 2019 by MF

In the previous blog post, we see how Flash Fill extracts First Name and Last Name from an email address in a format shown above.  I’ve also recorded a video for that post. Flash Fill is so smart to detect … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , | Leave a comment

Change the first letter to upper case, first word only please #Excel

Posted on July 19, 2018 by MF

This is a short story of mine, and an imaginary conversation in my head…  How to change the first letter (of first word only) to upper case in Excel? This was a question from a colleague sitting opposite to me.  … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 7 Comments

How to turn “1st January, 2017” into #Excel recognizable date?

Posted on November 5, 2017 by MF

Quite a long time ago, I wrote a post to discuss a trick to format date with “st”, “nd”, “rd”, etc… In this post, I am going to discuss the reversed way: Turning an English written date with “Dst MMMM, … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , | 8 Comments

Writing a long formula in steps

Posted on August 13, 2016 by MF

Writing a long formula is not easy, even for an advanced Excel user.  What I mean long is  a formula with many nested FUNCTIONS within a single formula.  The difficulty I am talking about is not related to whether you understand the … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , | Leave a comment

Text manipulation with Excel functions

Posted on July 23, 2016 by MF

We talked about RIGHT, LEFT, MID, UPPER, LOWER, PROPER, FIND, SEARCH, REPLACE and SUBSTITUTE in the past few weeks.  Now it’s time to put every thing together to solve a problem.  This is actually the most amazing part of using … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , , , , , | 6 Comments

RIGHT. I LEFT. In the MID of…

Posted on June 18, 2016 by MF

Obviously this post is about the most popular text related functions in Excel.  Meanwhile, it is also a message from me… Yes, you are RIGH! I LEFT my ex-company and have landed on a new job which is much more … Continue reading →

Rate this:

Posted in Formula | Tagged , , | Leave a comment

Make impossible possible

Posted on February 20, 2016 by MF

Convert text of specific pattern like “1d 2h 3m 4s” into real time (26:03:04) in Excel To kick start the Year of Monkey, let’s challenge the apparently impossible… Do you think it is not possible in Excel?  If you do, you … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , | 2 Comments

How Excel formula can save your time?

Posted on September 6, 2014 by MF

Extract number from a text string This post is about two things: How a poor system set up could drive you crazy? Why being good in Excel could save you lots of time in workplace? Another real work example.  I was … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , | 4 Comments