Tag Archives: REPLACE

Text manipulation with Excel functions

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

REPLACE vs. SUBSTITUTE in Excel

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

Rate this:

Posted in Formula | Tagged , | 2 Comments