Tag Archives: RIGHT

Pad a column to fixed length with #Excel formula

Posted on June 3, 2023 by MF

Here’s the situation: We have a column of values with various lengths, from 1 to 5 letters. We want to convert that into a fixed length of, say 5 letters, padding with zero(s). The following screenshot illustrates the requirement. How … Continue reading →

Rate this:

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

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

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

SUM Time in the end of text strings

Posted on July 25, 2015 by MF

Did you encounter a task like this?  I did.  Actually it is not as difficult as you may expect.  It could be done in just a minute IF the data is not too bad, like the one shown above. I … Continue reading →

Rate this:

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

Extract last word from a text string

Posted on November 17, 2014 by MF

There are many cases that we may just want the last word from a text string.  Typical example would be something like the last row in the above screenshot: There are many codes at the end of a text string … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 5 Comments