Tag Archives: REPLACE

Change the first letter to upper case, first word only please #Excel

Posted on July 19, 2018 by

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

Turn REPLACE function into “INSERT” function Continue reading →

Rate this:

Posted in Formula | Tagged , | Leave a comment

Text manipulation with Excel functions

Posted on July 23, 2016 by

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

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