How to use Excel's Replace and Substitute functions

Posted on
3,008 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
Provides a one size fits all solution for File Dialog calls for all MS office applications. Module contains function fncGetFilePathTRM() which does all the filter building for you. I've used a similar version of this for over 15 years, 1 module impo…
On the official Microsoft website we can find out curious data about Excel. In this post, I will tell you about the ones that have caught my attention the most.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month