How to use Excel's Replace and Substitute functions

Posted on
3,009 Points
Last Modified:
Experience Level: Intermediate
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
The Replace and Substitute functions will both swap out cell content, but they do it differently. The Substitute function will find content you search for, and the Replace function will count characters. Sometimes you want one method and sometimes you want the other. This video shows how they both work.
Author:Bob Flisser
The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.
Have you ever wanted to make your MS Excel spreadsheet more easy to follow?  Here is one way to do just that.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month