Tag Archives: LOWER

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

Case-insensitive SUBSTITUTE???…

Posted on July 16, 2016 by MF

We talked about REPLACE and SUBSTITUTE last week.  At the final note, I said that SUBSTITUTE is case-sensitive.  If we need to perform a case-insensitive SUBSTITUTE, it is indeed not an easy job unless we are talking a single letter … Continue reading →

Rate this:

Posted in Formula | Tagged , , | 9 Comments

UPPER, lower, Proper

Posted on June 25, 2016 by MF

I am wondering why these functions are not available in Word, but Excel? Don’t make me wrong.  I like these functions.  Nevertheless I am not a big fan (nor a small fan) of using Excel as word processor.  Whenever possible, … Continue reading →

Rate this:

Posted in Formula | Tagged , , | 10 Comments