How to use Excel’s Replace and Substitute functions

Replace and Substitute 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:

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Now certified in AI Ethics

Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance

Earned another AI certification

I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,

Get in touch

AI Workshop Inquiry/Booking