Tag Archives: REPLACE

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 FIND, LEFT, LOWER, MID, PROPER, REPLACE, RIGHT, SEARCH, SUBSTITUTE, Trim, UPPER | 6 Comments

REPLACE vs. SUBSTITUTE in Excel

Posted on July 9, 2016 by MF

Another pair of functions that has very similar meaning literally. Although I am not able to tell you the differences between “replace” and “substitute” in English, I can show you the differences of the REPLACE and SUBSTITUTE in Excel. … Continue reading →