Tag Archives: REPLACE

Understanding Find and Replace in #Excel

Posted on September 19, 2020 by MF

Find and Replace is a very handy tool in Excel. It helps you to find a value quickly. You may then replace the value found with another value, either one by one or replace all at one batch. To use … Continue reading →

Rate this:

Posted in Excel Tips | 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

Insert a text string into a specific position of another text string in #Excel

Posted on November 25, 2017 by MF

Turn REPLACE function into “INSERT” function Continue reading →

Rate this:

Posted in Formula | Tagged , | 4 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

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 →

Rate this:

Posted in Formula | Tagged , | 2 Comments